Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
comparing two excel filesPosted by Fred Hartnett on November 08, 2001 7:47 AM
I have two Excel (version 2000) documents. Both are similar in content. I need to merge the two and make one document.
Document #1 has info that #2 doesn't. The same can be said for document #2. Is there a way to compare the two in order that the edit process is simplified?
Re: comparing two excel filesPosted by Tom Urtis on November 08, 2001 8:46 AM
Can you please elaborate...do you want to combine the 2 workbooks into 1 consolidated worksheet, or compare to see if something is in one but not the other, or genrate one workbook with unique values, or something else?
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.