LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Dave Peterson
 
Posts: n/a
Default Is there a way to compare 2 spreadsheets with Excel?

Along the same lines as Jay's suggestion...

Myrna Larson and Bill Manville have developed a compare that's very nice.

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

But the bad news is that this does a cell-by-cell comparison. A1 compares to
A1, x99 to x99, etc.

If you insert/delete a row or column, then this won't work very well.

=======
Other alternatives that may work depending on what kind of differences you're
looking for:

Save each worksheet as a .csv file and use any comparison program you want to
compare two text files.

MSWord can compare two documents (or plain old text files), too.



Tavish Muldoon wrote:

Is there a way to compare 2 spreadsheets?

Almost like a Unix 'diff' command.

I have several variants of certain large spreadsheets with only minor
differences - and I want to review them. Find the differences and reconcile them.

Any suggestions?

Thx.

Tmuld.


--

Dave Peterson
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel converts Mapped drive to UNC - How to stop? Fred Links and Linking in Excel 1 January 20th 05 12:24 AM
Displaying frequency polygons in Excel (Statistics) Maxiem Charts and Charting in Excel 3 January 17th 05 11:45 PM
Creating GIFs in Excel 2003 for use in Dreamweaver Lou Crandall Charts and Charting in Excel 2 January 2nd 05 07:58 PM
Charting Data from Excel DavidM Charts and Charting in Excel 4 December 30th 04 02:31 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 08:05 PM


All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"