Most valuable professional
  • Hot Topics

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 3001 3002 Deductions 1004 1001 Total company cost Total Cost Centre POLOKWANE Income 3001 3002 3005 3006 Deductions

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

This thread is current as of January 4, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel