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. <(E-Mail Removed)>
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." <(E-Mail Removed)> wrote in message
news:675269EC-B294-4E18-8F86-(E-Mail Removed)...
> 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
>>