<div>
Just tried that one and it didn't help much. &nbsp;Have a big spreadsheet about 400 rows and about 40 columns to compare to sheet of similar size. Have a customer with a database and they think they have been doing data entry in two different versions. &nbsp;So I am trying to compare the table data in each to the other one. &nbsp;Was dropping it into an Excel sheet but maybe that is not the best way. &nbsp;Any suggestions?<br />
Thanks,Pat
</div>


Just tried that one and it didn't help much.  Have a big spreadsheet about 400 rows and about 40 columns to compare to sheet of similar size. Have a customer with a database and they think they have been doing data entry in two different versions.  So I am trying to compare the table data in each to the other one.  Was dropping it into an Excel sheet but maybe that is not the best way.  Any suggestions?
Thanks,Pat

<div>
Ok, found a way to use this one, but it would sure be nice to have one that highlights the cells that are different. &nbsp;Anyone have one that does that? &nbsp;Even if it cost a little it would be worth it.<br />
Thanks, Pat
</div>


Ok, found a way to use this one, but it would sure be nice to have one that highlights the cells that are different.  Anyone have one that does that?  Even if it cost a little it would be worth it.
Thanks, Pat

<div>
I will award points on this one and then post a different question for the question I possed in my last comment.<br />
Thanks, Pat
</div>


I will award points on this one and then post a different question for the question I possed in my last comment.
Thanks, Pat

<div>
<div class="content wysiwyg-content">
Do you know of any free, good, excel compare add in tools? &nbsp;<br />
Thanks, Pat
</div>
</div>


Do you know of any free, good, excel compare add in tools?  
Thanks, Pat

Compare two excel sheets 2007

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.