ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   comparing 2 workbooks automatically in Excell (https://www.excelbanter.com/excel-worksheet-functions/198541-comparing-2-workbooks-automatically-excell.html)

Joanne

comparing 2 workbooks automatically in Excell
 
is there a way to compare 2 workbooks automatically?

Gord Dibben

comparing 2 workbooks automatically in Excell
 
You are short on details but.............................

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.ZIP, unzip 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, 12 Aug 2008 06:58:01 -0700, Joanne
wrote:

is there a way to compare 2 workbooks automatically?



Joanne

comparing 2 workbooks automatically in Excell
 
Thanks so much. I'm new at using the intricate parts of Excel.

"Gord Dibben" wrote:

You are short on details but.............................

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.ZIP, unzip 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, 12 Aug 2008 06:58:01 -0700, Joanne
wrote:

is there a way to compare 2 workbooks automatically?





All times are GMT +1. The time now is 04:45 AM.

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