Comparing two Worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

editprod - 17 Aug 2007 05:27 GMT

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.

Reply to this Message

Dave Peterson - 17 Aug 2007 13:09 GMT

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.

> 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.

Signature

Dave Peterson

Reply to this Message

Stan Brown - 17 Aug 2007 18:13 GMT

Fri, 17 Aug 2007 07:09:14 -0500 from Dave Peterson
<petersod@verizonXSPAM.net>:

> 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

Signature

"First prove what you're saying, then whine about it."
-- /The People's Court/
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Reply to this Message

Dave Peterson - 17 Aug 2007 18:47 GMT

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!)

> Fri, 17 Aug 2007 07:09:14 -0500 from Dave Peterson
> <petersod@verizonXSPAM.net>:
[quoted text clipped - 17 lines]
> Stan Brown, Oak Road Systems, Tompkins County, New York, USA
> http://OakRoadSystems.com/

Signature

Dave Peterson

Reply to this Message

CLR - 17 Aug 2007 15:34 GMT

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

> 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.

Reply to this Message

Rate this thread: