Compare two similar files

[Gizmo]

Hi guys,

I wonder if there is a special function (or a "nice" VBA file) that allows
comparing two *.xls files with the same structure (15 tabs, on each tab the
same number of lines and columns).
I suppose that there were some minor changes done, however it seems to me to
be a foolish task to compare/check/audit it manually.

I'm looking (ideally) for a way to present it like this (example):

No Sheet Cell Value "File1"
Value "File2"
----------------------------------------------------------------------------
1 'Sheet1' L15 553.13
563.12
2 'Sheet7' A4 1464.00
1364.00
3 'Sheet10' B13 ABcd
abcd
4 'Sheet12' D5 Nomore
No more
....

Is it feasible? Is it a good way to address such an issue?
Thanks a lot for your help on this!

Gizmo

BTW: I've tried to use "auditing" tool, but it seems to work poorly if 1)
the data is on several sheets and 2) there are some functions involved (data
is send from one cell to another...).

 

[Gizmo]

Naturally, the presentation below is not reproduced correctly.
"Value "File2"", "563.12", "1364.00", "abcd", and "No more" should
constitute the last (5th) column and not be placed somewhere in between the
first (No) column, that is composed solely with the numbers 1, 2, 3, 4 ...

Sorry for this... Hope it was not too confusing.

Regards,
Gizmo

 

[Myrna Larson]

Go do www.cpearson.com and download the COMPARE.XLA addin that Bill Manville
and I put together.

 

[Myrna Larson]

PS: COMPARE.XLA compares two worksheets. To do all 15, you'll have to run it
15 times.

 

[Gizmo]

Thanks a lot Myrna,

It's fantastic!
Meets perfectly my needs...

Regds,
Gizmo