Compare Workbooks

[davehunter]

Hi Everyone!

I'm trying to find a macro that will do the following:

* Compare 2 workbooks containing 2 columns each (Surname & D.O.B)

* Remove any rows that exist in both workbooks e.g. Smith & 12.05.2007 in both (Note: these are not necessarily in same Row in both workbooks)

* Leave rows that only exist in one or the other workbook.

Your help would be very much appreciated.

Thanks!
Dave

 

[davehunter]

Workbook 1



Workbook 2