Compare 2 cells on sheet1 with 2 cells on sheet2 and copy unmatched rows to sheet3

Hello all. I have searched the forum and found the following code that I think will do what I need, but the changes I made do not produce any results:

Please Login or Register  to view this content.

Basically I sheet1 has columns A and B (item number and date that together identify the item) that need to be compared to each row on sheet2 columns A and B. If sheet1 does not match sheet2 then copy the row from sheet1 to sheet3. The columns are not matched from sheet1 to sheet2 independantly, but as a pair.

For example:

sheet1 sheet2
colA colB colA colB

z12 1/1/2001 as6 5/6/2007
z12 1/1/2004 f6 5/6/1999
152 1/3/2001 gh9 5/20/2007
z12 2/1/2001 z12 1/1/2001
999 7/1/2001 z18 1/1/2001

Since only the z12 1/1/2001 is common to both sheets, all the other rows should be copied to sheet3.

The code above runs and ends but there is no data on sheet3 or error.


Thanks in advance for your assistance,
Andrew