Originally Posted by julied d

Hi Julian

While you could write a script to do this I would think that initially
anyway it would be easier to use a formula.

What you would need to do is create a list on a separate sheet with
two columns, e.g.
A....................................B
OldNumber....................NewNumber
BK818...........................5679
etc

Once you have listed these save the sheet (give it a good name, e.g.
REFLIST). This sheet will then need to be used every day in the file
that you download your data into.

Once you have downloaded your daily sheet, insert a new column to the
right of the column that has the 'old numbers' in it
e.g
A...................B.........................C
Date.........OldNumber...........NewNumber
1/1/12.......BK818...................
etc

Now in the "new number" column use a formula to look up the old number
in the list and put the new number in:
=VLOOKUP(B2,REFLIST!$A$1:$B$51,2,0)

Then copy this formula down all your data.

You can then copy / paste special values the data in column C and
delete column B.

Hope this helps.
JulieD