Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Will Excel "compare" two worksheets or files?
I'm using MSExcel2003, SP2....
I already read about the technique where you can put two MSExcel spreadsheets side-by-side and *visually* compare...which is a very "manual" technique, but... Will MSExcel "compare" two worksheets and highlight differences for the user (like you can do in MSWord...where the resulting output highlights differences in red...great to for comparing differences in different versions of some text document)? If not, is there a software app (preferably in WinXP) that would at least give a "yes" or "no" on whether two files are identical (duplicates?) Thanks, George |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Will Excel "compare" two worksheets or files?
This isn't exactly what you are looking for but it might help. You could use the EXACT formula in a range of cells identical to those used in the two spreadsheets. Any occurences of false would indicate a difference. You could also try a macro which selected the set of occupied cells in one of the sheets and compared one by one to the other. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=548165 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Will Excel "compare" two worksheets or files?
George, take a look at Compare.xla, it is an add-in, written by Myrna
Larson and Bill Manville, it will compare the contents of two worksheets or workbooks. You can download it at Chip Pearson's site here http://www.cpearson.com/excel/whatsnew.htm about half way down the page -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "George" wrote in message ... I'm using MSExcel2003, SP2.... I already read about the technique where you can put two MSExcel spreadsheets side-by-side and *visually* compare...which is a very "manual" technique, but... Will MSExcel "compare" two worksheets and highlight differences for the user (like you can do in MSWord...where the resulting output highlights differences in red...great to for comparing differences in different versions of some text document)? If not, is there a software app (preferably in WinXP) that would at least give a "yes" or "no" on whether two files are identical (duplicates?) Thanks, George |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Will Excel "compare" two worksheets or files?
George,
try the addin Synkronizer. It may be what you are looking for. 30 days trial can be downloaded from www.synkronizer.com -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam George wrote in I'm using MSExcel2003, SP2.... I already read about the technique where you can put two MSExcel spreadsheets side-by-side and visually compare...which is a very "manual" technique, but... Will MSExcel "compare" two worksheets and highlight differences for the user (like you can do in MSWord...where the resulting output highlights differences in red...great to for comparing differences in different versions of some text document)? If not, is there a software app (preferably in WinXP) that would at least give a "yes" or "no" on whether two files are identical (duplicates?) Thanks, George |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula for an "if" "then" scenario linking 3 worksheets | Excel Discussion (Misc queries) | |||
Compare two worksheets with "contains" and not "exact" values | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Why is "History" a "reserved name" while naming Excel worksheets? | Excel Discussion (Misc queries) | |||
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming |