| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove Duplicate rows? | Excel Discussion (Misc queries) | |||
| compare and take out duplicate data | Excel Worksheet Functions | |||
| Remove duplicate rows based on 1 specific criterion | Excel Discussion (Misc queries) | |||
| Need macro to remove duplicate rows in a wksht with same order# | Excel Discussion (Misc queries) | |||
| how do I compare workbooks for duplicate data | Excel Discussion (Misc queries) | |||
Threaded Mode
