How to Compair two Excel files using Macro ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

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

Compair first 5 numbers 1
How to split an excel workbook in code and data 2
excluding records based on a table 3
Help with Macro that searches a Range for specified information 7
test mark 6
Macro to generate powerpoint slides 43
Macro for Creating Word Document!! 5
Export Macro to new Workbook based on Email Address 7

Back
Top