I have two work sheets in excel. When I type a name down in cell A1 in sheet1, I want it to take that name and go to the sheet2 and find that name in column A and copy whatever in the next cell (cell B) and paste it back in cell A1 of sheet1....Thanks you very much if any can help or can come up with something similar like that!!!!!!!!

Sincerely,

VBisgreat!