Hi, Best wishes!

I have attached a file which explains my problem.

It is that a table is to be compared with another table (which consists a lots of data) and need to be replaced with a code.

I feel that a macro only will do.

I appreciate any help. Thanks in advance.

acsishere.