the best way to get help is to provide a non-sensitive sample of the 2 spreadsheets

one approach would be

1. make a copy of the largest workbook

2. copy the second one into the new workbook (provided they have the same structure)

3. filter the duplicates