macro help column A to column B based on list

[PhoneBoy]

I'm sure that the answer is here, but I don't know enough about it to search intelligently.

Problem: I get a huge spreadsheet (10,000 lines or so) each month that I have to divide up and pay people. I have been using a method that I saw in this post

http://www.mrexcel.com/board2/viewtopic.php?t=167633&highlight=macro+replace+text

which Erik Van Geit proposed. I rename my worksheet as data and create a second worksheet called list where I put my replacement text. It works beatifully especially because I have to do this each month and my list changes as we open new stores.

What I am wanting to do is instead of replacing the text, I would like to create a new column with the info. For example, I am currently replacing 8857 with NC. I would like to keep 8857 in column B and add NC in column C. The if/then statements will not work due to the number of replacements that I have (I think).

Any help would be appreciated.

Thanks,
Scott

 

[PhoneBoy]

You are my hero. I left the code alone and just added a Blank Column A. One question, when it finished, it gave an error code, but it looks like it was where it didn't find some of my codes such as
8613
9508
etc.

This is also a good thing because it will alert me as to which codes I should have but are missing.

You don't know how much you have simplified what I was doing. I really, really, appreciate it.

Thanks again for all of your help.

 

[jindon]

One question, when it finished, it gave an error code, but it looks like it was where it didn't find some of my codes such as
8613
9508
etc.

The code should tell you when any one of "what" is not on "data" sheet. like

Following data not found

aaa
bbb
ccc

etc

 

[PhoneBoy]

agihcam and jindon - thanks again. I'm marking up these spreadsheets as I type. I have to do 8 of these every month with about 10,000 records (more on some). This is unreal. Thanks again for your help