Comparing two Worksheets

[editprod]

Does anyone know of a plug-in or program that can compare two same-named
XLS worksheets to compare differences in the cell data? Is there any
freeware or low-cost shareware? Thanks.

 

[Dave Peterson]

If you wanted to look at a cell by cell comparison to compare two worksheets
cell by cell (A1 with A1, x99 with x99...), you could try this addin developed
by Myrna Larson and Bill Manville.

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

If you think that a row or column was added or deleted, this kind of comparison
soon loses its effectiveness.

 

[Guest]

I use Jim Cone's fine commercial Add-in called XL Companion. It's available at

http://www.realezsites.com/bus/primitivesoftware/

Vaya con Dios,
Chuck, CABGx3

 

[Stan Brown]

Fri, 17 Aug 2007 07:09:14 -0500 from Dave Peterson

If you wanted to look at a cell by cell comparison to compare two worksheets
cell by cell (A1 with A1, x99 with x99...), you could try this addin developed
by Myrna Larson and Bill Manville.

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

Dave,

You might want to update your bookmark. The above URL now redirects
to

http://www.cpearson.com/excel/whatsnew.aspx

 

[Dave Peterson]

Thanks.

Chip has said that he's rewriting his pages, but the old URLs will redirect to
the new location.

(I have a lot of links to update!)