Compare worksheets to copy and paste data based on matching criter

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.
 
S

Sheeloo

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013 Merge Data 2
Help with macro comparing data in worksheets 4
Help needed with Macro designed to compare data... 2
Compare two worksheets in the same workbook and highlight difference 7
Button to insert rows on mutiple worksheets and copy text and info 1
Need help with VBA - complicated copy and paste 2
Copy data from 1 sheet to multiple worksheets 2
Compare Rows on different Worksheets and Output Difference's to other Worksheets. 3

Top