how do i compare two excel documents then cop

November 5, 2010 at 07:08:58
Specs: Windows XP
I basically have 2 different UPC catalog files that i need to merge into one. Some of the same data might be shared among the two but in different order so only the differences would need to be copied over.

Each document has the same column headers:
column a: vendor style number
column c: color
column f: description
column: k size
column: L UPC

how do i accomplish this???
excel 2007

See More: how do i compare two excel documents then cop

Report •

November 5, 2010 at 12:23:38
Try this in a backup copy of your workbook in case things go terribly wrong.

Copy everything except for the column headings from one list and paste it below the other list.

Select the entire range and do a Data...Filter...Advanced Filter, choosing the "Unique Records Only" option.

You should be left with a single instance of each item.

Report •
Related Solutions

Ask Question