Macro to Extract Duplicate Records

I have data on Sheet "Import Data"

I would like a macro to extract only the duplicated items in Col C to sheet "Duplicates"

Where there are duplicated Items, then extract all the the data , but only the duplicated data i.e based on those items that are duplicated in Col C


I have manually extracted these to show you what I require on sheet "Duplicates"


Your assistance is most appreciated

Thanks for the help, Much Appreciated

Thanks for your help nankw83.

I am familiar with advanced filter, which is a great technique