Compare Worksheets

[Marty]

Hello,
Does anyone know of a way I can compare the differences
between two worksheets. They should be absolutely
identical but there's too much information for me to scan
through and pick out the differences.

Thank you for your help

Marty

 

[CLR]

I use a commercial Add-in that works perfectly for this.........it compares
values, dates, formulas, formats, etc etc........it really saved my bacon
when I needed it and was well worth the money to me........even tho my
Company wouldn't spring for it, I bought it myself............on my first
usage it discovered 231 differences between my archived original and what
was supposed to be an "unchanged" worksheet..........saved me HOURS/DAYS.

I would provide the name but I don't know if it's proper on this newsgroup.

Vaya con Dios,
Chuck, CABGx3

 

[Jim Rech]

I would provide the name but I don't know if it's proper on this newsgroup

Go for it!

--
Jim Rech
Excel MVP
|I use a commercial Add-in that works perfectly for this.........it compares
| values, dates, formulas, formats, etc etc........it really saved my bacon
| when I needed it and was well worth the money to me........even tho my
| Company wouldn't spring for it, I bought it myself............on my first
| usage it discovered 231 differences between my archived original and what
| was supposed to be an "unchanged" worksheet..........saved me HOURS/DAYS.
|
| I would provide the name but I don't know if it's proper on this
newsgroup.
|
| Vaya con Dios,
| Chuck, CABGx3
|
|
|
| | > Hello,
| > Does anyone know of a way I can compare the differences
| > between two worksheets. They should be absolutely
| > identical but there's too much information for me to scan
| > through and pick out the differences.
| >
| > Thank you for your help
| >
| > Marty
| >
|
|

 

[CLR]

Okey......here you are......

The Add-in is called XLCompanion. It's available from
(e-mail address removed) (remove the XXX's)

Like I said, it really saved my bacon when having to compare two Excel files
that were "supposed to be the same".......it found 231 differences.

I whole-heartedly recommend it.

Vaya con Dios,

Chuck, CABGx3

 

[Dave Peterson]

And a free version:

A program by Myrna Larson and and Bill Manville.

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

It compares A1 to A1, B99 to B99...