Hi, i have a list of over 100,000 records - first name / last / position / company / email / phone number.

What i am looking for is a macro that will allow me to move all of the duplicate rows (based on the email address) to another work sheet. Leaving the unique. Or the other way around - moving the unique to be left with just the duplicates.

Been searching forums, have not managed to find a solution to my problem.
I hope you can help.

regards