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.


--
Rgds

Nitesh Mathur

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.

Nitesh Mathur wrote:

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.

--
Rgds

Nitesh Mathur

--

Dave Peterson

Link appears to be dead. http://www.cpearson.com/excel/Zips/Compare.ZIP
Is there another location for the file?
--
Regards

Rick
XP Pro
Office 2007



"Dave Peterson" wrote:

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.

Nitesh Mathur wrote:

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.

--
Rgds

Nitesh Mathur

--

Dave Peterson

http://www.cpearson.com/excel/Download.htm

Scroll down to "Compare"

I just downloaded the file in past 2 minutes.


Gord Dibben MS Excel MVP

On Mon, 8 Oct 2007 16:07:02 -0700, Rick S.
wrote:

Link appears to be dead. http://www.cpearson.com/excel/Zips/Compare.ZIP
Is there another location for the file?

Link appears to be dead. http://www.cpearson.com/excel/Zips/Compare.ZIP

That link is wrong. The correct link is
http://www.cpearson.com/Zips/Compare.zip


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Rick S." wrote in message
...
Link appears to be dead. http://www.cpearson.com/excel/Zips/Compare.ZIP
Is there another location for the file?
--
Regards

Rick
XP Pro
Office 2007



"Dave Peterson" wrote:

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.

Nitesh Mathur wrote:

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.

--
Rgds

Nitesh Mathur

--

Dave Peterson