Import & Assign Reference

[calgary234]

I'm hoping someone can help with the following. I'm importing a financial report into Excel from SAP, unfortunately there is no reference to locations but there is a common occurance. Each location starts out with the same line/row label "All Costs Elements".

I also know the sequence or order of the locations imported and these are located on a seperate worksheet table.

Alternative 1) What I'd like to do is if cell B1:B1000="All Costs Elements", then paste into column A="PC050400 before the next occurance, continue with B1:B1000="All Costs Elements", then paste into column A="PC050401, etc.

Alternative 2) Would see a macro cut out the seperate locations and copy them to an individual work sheet for each location.


Thanks for your help,
GB

[olasa]

Well you could do something like this:

A2: =IF(B1="All Costs Elements","PC0"&(RIGHT(A1,5)+1),A1)
Copy down
I think you can tweek it to fit your needs.


Ola Sandstrom