Copy data from worksheet 2 to worksheet 1 if match found

Objective: Use a common key value (barcode) to combine data from 2 different lists

Logic
Compare value of each row in col A of Sheet 1 to all rows in Col A of Sheet 2
If a match is found, move the values from Sheet 2 Col B to Col C to Sheet 1 Col B and Col
If no match is found, leave blank


Example
Sheet 1 A2 = 1
A search of Sheet 2 Col A finds a value of "1" in A11
Therefore, move values from Sheet 2 B11 and C11 to Sheet 1 B2 and C2
Moving (versus copying) will allow me to see which barcodes did not have a match


Check value of each row in Col D against values in all rows of Col A If a match is found, copy the value in Col B to Col E and the value in Col C to Col f If no match is found, leave blank

Sample spreadsheet attached.

Thanks in advance for your help!

TSSRob,

If you hadn't specifically said you wanted to move (cut) the data vs just copy it, I would argue that the data could be pulled using a VLookup() formula. Since you do want to move the data from sheet2 to sheet1, you should be able to use the following macro:

Please Login or Register  to view this content.