![]() |
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 |
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 |
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 |
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