M
Monomeeth
Okay, what I have is one workbook with two worksheets.
The first worksheet has data in the following columns:
A B C D
AGS NAME DATE User ID
The second worksheet has data in the following columns:
A B C D E F G
User ID Name Level Team ESS SAP Start
What I need is a macro to compare the two worksheets to identify the rows in
the second worksheet that contain a User ID which also exists in the first
worksheet. When a match is found, I want the macro to copy the data which is
in Column A and Column C of worksheet 1 into the corresponding rows in
worksheet 2 in Columns H and I.
Any help would be greatly appreciated!
Thanks,
Joe.
The first worksheet has data in the following columns:
A B C D
AGS NAME DATE User ID
The second worksheet has data in the following columns:
A B C D E F G
User ID Name Level Team ESS SAP Start
What I need is a macro to compare the two worksheets to identify the rows in
the second worksheet that contain a User ID which also exists in the first
worksheet. When a match is found, I want the macro to copy the data which is
in Column A and Column C of worksheet 1 into the corresponding rows in
worksheet 2 in Columns H and I.
Any help would be greatly appreciated!
Thanks,
Joe.