If the rows are complete duplicates - in other words, each cell in one of the
duplicate records contains the exact same thing as the same cell in another
duplicate, then it is easy.

Create a 3rd worksheet and *copy* the data from your 2 current worksheets
into the new one, one set of data immediately below the other set.

Now, with any cell in the pasted data selected, use the Filter-Advanced
Filter option on the Data menu and choose "Copy to another location" and
check "Unique Records Only", then click in the Copy to: box and select a
range on your worksheet that is empty and large enough to hold all the unique
records. Click on OK and Excel will do the work for you.


"PatrickL" wrote:

I really need help.

I have two worksheets with data in columns A-G. Column B has content like
"HDMU4524565". This is in column B of both worksheets. There are multiple
duplicates in Column B on both worksheets. I need to combine the two
worksheets keyed on column B and have no duplicates.

I also need to pull the data in the other columns over that corespond with
the entries in column B.

Example:

Column A Column B Column C Column D Column E Column F
Column G
Hunter HDMU454657 SMITH 7/5/05 8/5/05 8/5/05
YES

My boss is on me to do this report more efficiently.

Any help is appreciated.