I have a manual task that is done daily that looks like it should be automated. I am just getting started with VBA, and any help would be appreciated.

I have 2 workbooks. The first is a partial listing of people (usually 20-30 in the list) and it has 1 sheet, with columns for Fname, Lname, value1, value2, value3

The second workbook has a complete listing of people (usually 300 or so people) and it has 3 sheets with the same 5 columns - Fname, Lname, value1, value2, value3. Don't ask me why they split this workbook into 3 sheets. Probably to make it harder.

I need to run through the first workbook and find the matching first/last names on the second workbook. When found, I need to replace value 1, 2 and 3 on the second workbook with the first workbooks values. A person can be in any of the 3 sheets in the second workbook.

Any help would be appreciated.

Thanks,

John