Compare contents within all cells of 2 excel files

**codepin** · 03-23-2009, 06:06 AM

Is there anyway to compare 2 excel files, see whether the contents are the same or not? The last modify time / Create time can be different, which is ok for me. Just need to compare the formulas cell by cell, worksheet by worksheet, preferrably not using macros. Any suggestion welcome, many thanks in advance.

**Cheeky Charlie** · 03-23-2009, 06:33 AM

put:
=<workbook1><sheet1!>A1=<workbook2><sheet2!>A1
into a third workbook and copy across, then play find the FALSE (which can be achieved by searching values for FALSE...)

Not terribly beautiful but does the job without mucking around.

HTH

**codepin** · 03-23-2009, 06:51 AM

Originally Posted by Cheeky Charlie

put:
=<workbook1><sheet1!>A1=<workbook2><sheet2!>A1
into a third workbook and copy across, then play find the FALSE (which can be achieved by searching values for FALSE...)

Not terribly beautiful but does the job without mucking around.

HTH

Hi Cheeky Charlie,

Thanks for your prompt reply. Yes this way has been used, but put off due to the size of the files. Each has 120 sheets, all different, most of have filled with data from A1: DA3000 over. Sometimes the copy & paste action freeze my excel. Anyway can minimise my keystrokes?

**Cheeky Charlie** · 03-23-2009, 07:40 AM

preferrably not using macros

um...

can't think of any

**codepin** · 03-23-2009, 12:23 PM

Originally Posted by Cheeky Charlie

um...

can't think of any

Well, if Macro is the only way, would it be possible to make it simple? I'm afraid my level is novice within novice. Can't even figure out the good things of the Index-Match mix.

Speaking of the devil, is there any good and simple thread about the Index-Match mix in this forum? Kindly please let me know the link. My thanks in advance.