Compare worksheets to copy and paste data based on matching criter
 

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!

Compare worksheets to copy and paste data based on matching criter
 

You can use VLLOKUP for this..
Move or Copy the UserId column as the first Col in Sheet 1
Then enter this in H1 of Sheet 2
=Vlookup(A1,Sheet2!A:D,2,False)
and this in I1 of Sheet 2
=Vlookup(A1,Sheet2!A:D,3,False)
Copy both down to the end...

For those Ids which are not there in Sheet 1 you will get #N/A which you can
suppress by
=ISNA(Vlookup(A1,Sheet2!A:D,2,False),"",Vlookup(A1 ,Sheet2!A:D,2,False))
and
=ISNA(=Vlookup(A1,Sheet2!A:D,3,False),"",=Vlookup( A1,Sheet2!A:D,3,False))

"Monomeeth" wrote:

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!