Forum Discussion
Finding duplicates between two different workbooks
I am looking for the best and simplest way to identify duplicates between two worksheets in different workbooks. The data structure between the two worksheets is the same. My preference would be...
ECJ53 The simplest would be to copy/paste data from both sheets into one. Then select the entire range with data and select Remove Duplicates on the Data ribbon (Data Tools group), and follow the instructions.
- Thanks, I'll give that a try.
