Compiling data
 

I have two worksheets that I need to combine. Sheet1 has usernames with
answer codes. Sheet2 has the same code and the answer. Many users on sheet1
have the same answer. How can automate this. I am thinking with Macros, but I
have had trouble with using the find and replace in the macro. I want to try
avoiding copying and replacing thousands of entries. Thanks for any help.