Macro to find duplicate entry and copy in other sheet

[deven_deesha]

Hi,

I have a sheet with multiple columns. I want to find out duplicate entries from the sheet and copy and paste that data along with other columns in other sheet. Can some one please help me out on this?

Thanks,
Shri

 

[pbornemeier]

How many columns? What columns could contain duplicates? Should duplicate values in different columns be copied? More details please. This could be very slow and take a very long time.