Question: how to copy duplicates in excel to another sheet?
Answer: Click on any cell with data in your worksheet.
Click the Advanced button in the Sort & Filter group on the Data.
In the Advanced Filter dialog box: Choose the Copy to another location radio button.