comparing two workbooks

[CharlieB]

Is there a way to automatically determine the differences
between two similar workbooks (i.e., they have the same
worksheets and columns/rows on each worksheet, but there
may have been changes to individual cells with the same
sheet-column-row location)?

 

[Dave Peterson]

One version that does the cell by cell comparison is at Chip Pearson's site. It
was written by Myrna Larson and Bill Manville.

http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

 

[CharlieB]

Thanks...let you know how it works out.

-----Original Message-----
One version that does the cell by cell comparison is at Chip Pearson's site. It
was written by Myrna Larson and Bill Manville.

http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla


--

Dave Peterson
(e-mail address removed)
.

 

[Guest]

After holding my breath and crossing my figures, I went
ahead and installed the macros (you know the dire warnings
Excel gives you when you do that). Works as advertised
and does everything I wanted. Once again...thanks!

Charlie