Thread: Mass Find and Replace Macro

Hi

I have a workbook with three sheets (see attached). The "Import Data" sheet will have data imported from text files (I have only included one in the work book but there could be several hundred). Columns C has numbers which can be found on the "Item ID" sheet, with the cooresponding name in column B. Similarly with Column K and the "Station ID" sheet.

What I am trying to do is make a macro that will Find and Replace all of the numbers in columns C and K in the "Import Data" sheet with their cooresponding values from the "Item ID" and "Station ID" sheets.

Any help/advise would be greatly appreciated.

Thanks in advance.

Hi,

No need for a macro. Why not just use a couple of VLOOKUP() functions in two helper columns. e.g.

O2: =VLOOKUP(C2,'Item ID'!$A$1:$B$25577,2,FALSE)
P2: =VLOOKUP(K2,'Station ID'!$A$1:$B$5329,2,FALSE)

copy O2:P2 down your list then finally select the values in column O, copy them and paste them back to column C as Values. Ditto with columns P & K

HTH