Move rows with duplicate values in column J to next worksheet

[theletterh]

Hello all,

I'm looking to move all rows with duplicate values in column J to the next worksheet, entitled "Duplicates". Specifically, if two rows have 12345 in column J, I'd like both rows to be moved. The below code only moves the duplicates after the first instance. Could anyone help me adapt this code to move all rows with duplicate values in column J?

Thank you!

Please Login or Register  to view this content.

[ARGK]

Hi
have a look at this link from Paul Edstein which may help you.

http://www.msofficeforums.com/excel-...new-sheet.html

Good luck.
Tony

[theletterh]

Thanks Tony! That did the trick.