ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I do a file compare of one excel spreadsheet to another? (https://www.excelbanter.com/excel-worksheet-functions/22722-how-do-i-do-file-compare-one-excel-spreadsheet-another.html)

stephen

How do I do a file compare of one excel spreadsheet to another?
 


Gord Dibben

stephen

The add-in, Compare.xla written by Myrna Larson and Bill Manville, allows
you to compare the contents of two workbooks and highlight differences.

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

Look for Compare.xla at 14-June-2000

Download Compare.xla and add it with rest of your your add-ins.
On Tools Menu, select add-ins and check in (tick in)Compare Worksheets.
From tools menu then select Compare Sheets and follow instructions.


Gord Dibben Excel MVP

On Tue, 19 Apr 2005 13:03:05 -0700, "stephen"
wrote:




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com