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 to identify the lines and create a list, OR, delete the "duplicate" from one of the worksheets, then I can merge the two worksheets into one document.
@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.