Data Matching

[timbo1957]

Hi,

I have two identical worksheets Sheet 1 & Sheet 2 with a columns of reference numbers starting in B2 on both sheets.

Could someone give me a macro to run down Sheet2 and if the ref number in B2 does not exist on Sheet1 copy the whole row to Sheet3?

Thanks

[IlseVL]

Try putting a VLOOKUP in the last column of Sheet2. =IF(ISERROR(VLOOKUP(B2;Sheet1!B:B;1;FALSE));"X";"")
Then loop the last column and look for X.

If X, copy the row.

[Kyle123]

maybe:

Please Login or Register  to view this content.

Though a sample workbook would help