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.
--
If you can measure it, you can improve it!