Excel: Formula or VBA to retrive information

Good day Please assist I have in column A the following: A4 = Total Cost centre LONMIN with a lot of other information below it in the other Rows, e.g. Total income, Deductions, etc. Still in Column A I will have Total Company Cost with a total in Column c in the same line, e.g A22 = Total Company Cost and C22 = 71703, Then in Column A the following with no lone break A23 - Total Cost Centre Polokwane With the same as the above, the number of lines in between each cost centre differ I need to remove the Total Cost Centre before the name of each (as in line A4 and A23) and then place the name only in Column B, I think this is a LEFT or Right formula. Then I need to move the total for each centre to Column C next to the name i hope this makes sense What it looks like now:

Total Cost Centre LONMIN
Income 20
3001 10
3002 10
Deductions 5
1004 2
1001 3
Total company cost 18
Total Cost Centre POLOKWANE
Income 40
3001 10
3002 10
3005 10
3006 10
Deductions 10
1003 1
1002 2
1001 3
1004 4
Total Company Cost 30
Total Cost Centre BRICKLAYERS

This question generated 30 answers. To proceed to the answers, click here.

This thread is current as of January 04, 2014.

For more resources for Microsoft Excel