Hi
I wonder if you can help me. I am attaching an Excel 2000 file tha
shows and extract from our Financial System. Basically there are
columns- Cost Centre, Accounting Codes and £.
There is a cost centre name (in red) in the subtotal row in th
Accounting Codes column. What I would like to do is to write a macr
that will search the column "Accounting Codes" for the cost centre nam
and then paste that name in the Cost Center column for each of the row
that belong to that cost centre up to the subtotal line.

Thank you in advance
Regards
Nija

Attachment filename: test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45028
--
Message posted from http://www.ExcelForum.com