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
Bookmarks