Hi,
I have 2 Excel Sheets with the same columns and formats that I would like to compare and end up with two new sheets (1) containing only the unique records derived from both sheets and (2) another sheet with the duplicate records, identifying the cells that caused the duplication. I've tried the Advanced Filter functon but this just created the unique records. I do not know which were the duplicate records and which columns caused the duplication. Is there a way to do this with a macro ?
Thansk in advance
frank
I have 2 Excel Sheets with the same columns and formats that I would like to compare and end up with two new sheets (1) containing only the unique records derived from both sheets and (2) another sheet with the duplicate records, identifying the cells that caused the duplication. I've tried the Advanced Filter functon but this just created the unique records. I do not know which were the duplicate records and which columns caused the duplication. Is there a way to do this with a macro ?
Thansk in advance
frank