Hi,

Do the following:

1. Select range of data in the Second sheet.
2. On the Data menu, point Filiet , and then click the Advanced Filter. The
Advanced Filter dialog is displayed.
3. Under Action, click Copy to another location.
4. Click the Unique Records only Chceck box.
5. Click OK to return to the Worksheet.
6. Copy records from the Filtered data and paste in the Sheet 1.

For more information about how to use Advanced Filter, please refer to the
topic on Advanced Filter in the Microsoft Excel online help.

Challa Prabhu

"Ruth" wrote:

I need to merge two spreadsheets containing product listings. The first has
the headings: U/M PRODUCT# BRAND DESCRIPTION U/M2 DEALER
A DEALER B DEALER C

The second has the headings: U/M PRODUCT# BRAND DESCRIPTION
U/M2 DEALER PRICE

Each has many of the same entries, but each has unique entries also. The
Product #'s are alphanumeric. I need to combine all the entries, check for
duplicate product #'s, and then I will manually delete the rows I don't wish
to keep.

Any suggestions? Thank you.

Ruth