How to Compair two Excel files using Macro ?

N

Nitesh Mathur

I have two excel files with similar data ( not exactly same but column names
are same), I want to compair both file data using Macro and find out those
cells which have not common in first file to second file.

Can any body help me.
 
D

Dave Peterson

Myrna Larson and Bill Manville have developed a compare that's very nice.

http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

But the bad news is that this does a cell-by-cell comparison.
A1 compares to A1, x99 to x99, etc.

If you insert/delete a row or column, then this won't work very well.

=======
Another alternative that may work depending on what kind of differences you're
looking for (values, not formulas, not formatting, not comments, not objects):

Save each worksheet as a .csv file and use any comparison program you want to
compare two text files--like MSWord.
 
C

Chip Pearson

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Compair first 5 numbers 1
Cell data entering slow! 0
Excel - Wich Function should I use? 1
Merging from an Excel file with graphics 1
Embed the same Excel multiple times 0
Word macro that can call cells out of Excel for a find and replace 0
excluding records based on a table 3

Top