M
Mr_Philip
Hi!
Ok, so I have a list of cost centres e.g 2000,2411,2582
these have been replaced with new cost centre numbers e.g
8500,8548,8449
so that now:
2000 = 8500
2411 = 8548
2582 = 8449.
I will have spreadsheets submitted where the old cost centres will b
referenced.
What I want to do is; search the spreadsheet for the old cost centres
and replace the value with the corresponding new cost centres
something faster than a simple find and replace because there ar
hundreds of cost centres.
:confused
Ok, so I have a list of cost centres e.g 2000,2411,2582
these have been replaced with new cost centre numbers e.g
8500,8548,8449
so that now:
2000 = 8500
2411 = 8548
2582 = 8449.
I will have spreadsheets submitted where the old cost centres will b
referenced.
What I want to do is; search the spreadsheet for the old cost centres
and replace the value with the corresponding new cost centres
something faster than a simple find and replace because there ar
hundreds of cost centres.
:confused