Help for compare 2 data table in excel format!`

  • Thread starter Thread starter AAA
  • Start date Start date
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
 
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).
 
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...
 
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.
 
Back
Top