ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel change compare (https://www.excelbanter.com/excel-discussion-misc-queries/206822-excel-change-compare.html)

LeeAnn[_2_]

Excel change compare
 
I need to compare two Excel documents and list out the differences between
the two. I did not find any Out of the Box (OOTB) capability in Excel to do
this. Are you aware of any 3rd party OOTB tools that will provide this
capability?

-Thanks


Sean Timmons

Excel change compare
 
Depends on what you are looking for when you mean differences. Are you
talking any and all diferences from one workbook to another? Don't know of
anything that covers that at all.

If you are looking for changes by sheet, you could actually just use VB
programming to compare cell by cell...

"LeeAnn" wrote:

I need to compare two Excel documents and list out the differences between
the two. I did not find any Out of the Box (OOTB) capability in Excel to do
this. Are you aware of any 3rd party OOTB tools that will provide this
capability?

-Thanks


ShaneDevenshire

Excel change compare
 
Hi,

There is no feature built into Excel to do this, but people have create
them. Try Googling Compare Excel Files


If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"LeeAnn" wrote:

I need to compare two Excel documents and list out the differences between
the two. I did not find any Out of the Box (OOTB) capability in Excel to do
this. Are you aware of any 3rd party OOTB tools that will provide this
capability?

-Thanks


Gord Dibben

Excel change compare
 
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 to your Office\Libray
folder.

On Tools Menu, select add-ins and checkmark Compare Worksheets.
From tools menu then select Compare Sheets and follow instructions.


Gord Dibben Excel MVP




On Fri, 17 Oct 2008 11:47:01 -0700, LeeAnn
wrote:

I need to compare two Excel documents and list out the differences between
the two. I did not find any Out of the Box (OOTB) capability in Excel to do
this. Are you aware of any 3rd party OOTB tools that will provide this
capability?

-Thanks




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

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