Replacing Numbers from One Sheet to Another

[wwilli41]

Hello Everyone,

I help writing a macro that can replace numbers on one sheet from a reference chart. So if the first sheet says 10 in one cell, it will use the reference table with the information 10 in one column and 3000 in the next column and will replace the 10 on the first sheet with 3000.

Please let me know if any more information is necessary.

Thank you,

Wes

[steeladept]

Is there a reason you want to do it in a Macro instead of a simple VLookup? If so, try recording a Vlookup example to see how to code it and edit that. Otherwise just use the Vlookup (or HLookup if it isn't a vertical refeerence chart).

[jindon]

Assuming the lookup list in Sheet2 starts from A1:B1 down.
The numbers to be replaced are in Sheet1.

Please Login or Register  to view this content.