Compare Two Simple Workbooks & Remove Duplicate Rows
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 i.e. Not
Both in Row 8)
* Leave rows that only exist in one or the other workbook.
Your help would be very much appreciated.
Thanks!
Dave
|