Identifying duplicate entries

L

leimst

Hello,

I have a column of numbers that is very large. As a matter of fact, it is a
bout 112,000 rows so it won't fit on one worksheet since Excel only has a
65,536 row capability so it is on 2 worksheets. I would like to be able to
search column H in both the first worksheet, "Set 1" and the second
worksheet, "Set 2" for any duplicates. When a duplicate is found I would
like to copy that entire row to another worksheet. Would this be a fairly
simple task?

Any help would be greatly appreciated!

Brian
 
N

NoodNutt

G'day Brian

Check out Ron DeBriuns website

http://www.rondebruin.nl/copy5.htm

Copy records with the same value in a column to a new sheet or workbook

There are 5 different example for you to have a look at

1. Create a new sheet for one unique value (AutoFilter)
2. Add data to an existing sheet (AutoFilter)
3. Create a new sheet for all Unique values
4. Create a new workbook for all Unique values
5. Create a new sheet for all Unique values or paste it below the existing
data if the sheet exists

you may find it helpful

HTH
Mark.
 
Top