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.