Moving Duplicate records to new sheet

Woolstar · #1 12-23-2011, 02:42 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Construct a summary sheet by summing up from one or more than one sheet.	PRADEEPB270	Excel	1	11-04-2011 03:46 AM
Merge Doc skips records	eonelson	Excel	11	01-30-2011 03:49 PM
Moving formula range multiple cells when moving sum over one cell	FraserKitchell	Excel	4	02-26-2010 10:38 AM
copy cell from sheet 2 to sheet 3 macro	slipperyjim	Excel Programming	1	02-18-2010 01:31 AM
Help with consolidating multiple records into one	wbiggs2	Excel	0	11-30-2006 01:02 PM