PDA

View Full Version : Need VBA urgently......



Pete
08-03-2007, 02:04 PM
To all the cleaver people oy there....

Need urgent help to solve a problem...........

I have attached the spreadsheet below (excel 2003 version).

I'll explain the format: (Col A - portfolio name in singular format with id in col c and Combined portfolio i.e (barclay 1 + barlcay 2 = Barclays 1+2 (as per col F).....i hope i have explained this properly.....

I need help in combing the data in col A (via vba) to a finished product as that shown in col F.......(as per above example).....

If you need to ask any question just write back....once again thanks...

many thanks

Pete

paulked
08-03-2007, 07:08 PM
What is the formula for working this out? It doesn't equate with the data on your sheet!

Regards

Paul Ked

Pete
08-04-2007, 06:15 AM
Hi Paul

I have no forumla at the moment....i was wondering if you could possibly help....

What i need only applies to the datain col A.....i need to combine data in col A and the end result being that shown in col F...........

I have no idea how to go about this.........

thanks...