Code needed to move duplicates to another worksheet

**collinlo** · 11-15-2012, 10:59 AM

Hello

I have a spreadsheet that would normally have 6000+ rows that I need to move duplicates to a different worksheet. I can find forums that show how to delete but I do need to retain the data. The only column that needs to be checked against is A, but all of the row needs to be moved for any duplicates found. Help or guidance on this would be greatly appreciated.

**simeon.hruby** · 11-15-2012, 11:27 AM

Collinlo,

I think this might be what you are looking for. Let me know if you need anything else!

Simeon

**mike7952** · 11-15-2012, 11:59 AM

Give this a try

Please Login or Register  to view this content.

**collinlo** · 11-16-2012, 07:19 AM

This forum is the Bees Knees - thanks to you both for the code. The one from Simeon did what I needed except that it only ran on 12 entries as in the dummy spreadsheet, however I have learnt enough via this forum to know how to edit it to fit my requirements. Mike, yours did all that was required. Again thanks to you both, very much appreciated