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