Reconciling Data

Hi,

I have two sheets of data that can be seen in the attached file.

I need to run a macro to match the values in Columns A,B,D.

Preferably the result would be the lines that don't match appearing on sheet 3.

Sheet 1 Column A to match to Sheet 2 Column A

Sheet 1 Column B to match to Sheet 2 Column B

Sheet 1 Column G to match to Sheet 2 Column DTest Rec.xlsx

Thanks,

Try this:

Please Login or Register  to view this content.

Thanks for this code. When I run the macro, it comes up with the error code "Can't execute code in break mode".

The line highlighted is i = i + 1

That issue has been fixed, but when I run the code no results appear on Sheet3