Identifying duplicates over mulitple sheets with 3 criteria

[PHUTCH]

Greetings

I have a problem and was wondering if you fine gentlemen could assist me. As the title suggests I am trying to reconcile two sheets in a workbook, highlighting any duplicates (or more specifically, anomalies that don't match) based on criteria in all 3 columns. I have tried the concatenation/conditional formatting method but in my case it will require a fair bit of formatting for a task I will have to do regularly, so I was seeking a VBA based solution.

I have attached an extract of my data to highlight what I mean. In the extract, what I want to see highlighted (possibly on a separate column to the side?) is;
- Row 2 on sheet 1 does not match anything on sheet 2
- Row 2 on sheet 2 does not match anything on sheet 1
- Row 4 on sheet 1 has a match on sheet 2 (row 3 on sheet 2)
- Row 3 on sheet 1 does not match row 4 on sheet 2 (col 3 is different)

Apologies if this is not clearly presented, I just want to eliminate rows with matches between 2 sheets so i can see any anomalies on either sheet.
Again thank you for your time.

Extract.xlsm

[OllieB]

The following routine should do what you ask:

Please Login or Register  to view this content.

[PHUTCH]

Genius!
Works perfectly, thank you very much for the quick reply, and a special thank you for explaining your script within it.
Cheers

[OllieB]

Genius!
Works perfectly, thank you very much for the quick reply, and a special thank you for explaining your script within it.
Cheers

You are welcome! Will you please update the title of your post to show that your question has been answered.

[OllieB]

Phutch,

Will you please mark your request as solved. Thanks