Syncing data from another sheet

[dan_man555]

I'm new to excel macros and am getting a little stuck.

I have 2 sheets.

The first is a list of consecutive numbers, with a word next to it.

On a new sheet, I want to be able to list numbers in any order I like, and then have a macro that reads each number, looks for it on the other sheet, and places the corresponding word next to the matching number on the second sheet.

I'll attach a simplified version to try to show what I mean. The real one has hundreds of values, and would be too tedious to map them all.

Any help would be greatly appreciated.

[Richard Buttrey]

Hi,

Why not just use a standard VLOOKUP()? There's no need for macros.

C2 copied down.

Please Login or Register  to view this content.

[dan_man555]

Hi,

Why not just use a standard VLOOKUP()? There's no need for macros.

C2 copied down.

Please Login or Register  to view this content.

The idea is that I should be able to change the numbers in sheet 2, and then get an updated letter from the key in sheet 1 when I click sync.

[dan_man555]

Oh, I see now. Very cool.

Thanks a lot.

Results for anyone interested.