Help for compare 2 data table in excel format!`

A

AAA

I got 2 data table in excel format, but I want to know the different between
2 table!
For instance,
Table 1, Table 2,


Inventory ID Qty InventoryID Qty
CC2210 5 AA1101 5
CC2211 8 CC2210 9
CC2212 100 CC2211 160
......

Between 2 table, I want catch the inventoryID AA1101 IS THE DEFFERENT.

How ahould I do ??

Thanks!

Danny
 
D

Dave Peterson

If you're looking for these type changes, it might be best to save your file as
a text file (.csv or .prn??) and use another program that can compare them
(MSWord has that ability).
 
A

AAA

please give me instruction!

Thanks!

Danny


Dave Peterson said:
If you're looking for these type changes, it might be best to save your file as
a text file (.csv or .prn??) and use another program that can compare them
(MSWord has that ability).
Click to expand...
 
D

Dave Peterson

Open the first workbook.
Change to the sheet that you want to use to compare
then File|SaveAs
choose file of type: CSV (comma delimited)(*.csv)
save it to a location you'll remember.
close this file.

Repeat this procedure with the second workbook.

Close excel and open MSWord.

Open one of the .csv files.
tools|compare and merge documents
point at the other .csv file.

See what gets marked as changed.
 
Top