Comparing 2 Excel files

L

LAF

I have 2 Excel spreadsheets each with about 7 sheets in them tha
contain tables with data. Each sheet has a header, which describe
what is in the column. Our customer would like us to create a progra
that will compare the 2 Excel files and list out what is differen
between the two of them. For example, there may be new rows of dat
that is in one file but not in the other, rows of data may have bee
deleted, or the information in a row may have changed. Is there an
way that the tables can be compared between the two files
 
J

jeff

Hi,
Take a look:
jeff
-------------------------------------------
Hi,

On July 6, Dave Peterson wrote this:

jeff
------------------------------------------------
It depends.

Myrna Larson and and Bill Manville wrote an addin that
compares two worksheets
on a cell-by-cell basis.

A1 is compared with A1. B99 to B99. If one of the users
inserted (or deleted)
rows (or columns), then this cell-by-cell comparison
breaks down.

Here's a link to the program (kept at Chip Pearson's
site):
http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

But if one of your consultants inserted a new row 1 (or
deleted column A), then
you'd find a bunch of changes right away.
 
Top