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