Comparing two excel sheets,the never ending quest

[kevs1]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

The most important feautre of Excel somehow does not exist. But I keep asking.
You have 2 workbooks with 5000 file names. a few don't match.
How can I know quickly which files are different from each other.
Why have engineers of Excel not made this feature????

I've heard there are third party apps for Windows, I have not seen a good one for Mac. thanks.

 

[Bob Greenblatt]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

The most important feautre of Excel somehow does not exist. But I keep asking.
You have 2 workbooks with 5000 file names. a few don't match.
How can I know quickly which files are different from each other.
Why have engineers of Excel not made this feature????

I've heard there are third party apps for Windows, I have not seen a good one
for Mac. thanks.

I think we already answered this. Not about why the feature is not present -
the way to do this.

You have 2 sheets. Make a third sheet. In cell A1, enter the formula
=sheet1A1=sheet2A1. Of course use your sheet names. Then fill the formula
down and to the right for as large an area as you wish. The cells containing
FALSE are different on the 2 sheets.

 

[Bob Greenblatt]

I think we already answered this. Not about why the feature is not present -
the way to do this.

You have 2 sheets. Make a third sheet. In cell A1, enter the formula
=sheet1A1=sheet2A1. Of course use your sheet names. Then fill the formula
down and to the right for as large an area as you wish. The cells containing
FALSE are different on the 2 sheets.

OOPS, tying to fast. The formula should, of course, be:
=sheet1!A1=sheet2!A1

 

[kevs1]

Bob, tried but got this:

<http://img159.imageshack.us/my.php?image=picture1kj1.jpg>

 

[kevs1]

Would love to solve this, but it's a brick again, correct?

 

[gimme_this_gimme_that]

Well (e-mail address removed).

Everything has a price doesn't it.

For starters - tell me if you know enough to install the AppleScript
Perl module into your local version of Perl.

This lets you read and write to Excel and match and manipulate data in
Perl.

If you get this far...

Email me a representative sample of the workbooks and tell me how much
you'd pay for a solution by Monday.

As to why engineers of Excel haven't made this possible? Well, there's
the budget issue of creating a new VBA compiler, theres the fact that
most Mac Excel users aren't power Excel users, there's the fact that
you can run Excel for Windows using Parallels on a Mac, and there's
the fact that Microsoft has other higher priority projects, and
there's the fact that real power users can figure out how to get the
job done using AppleScript.

 

[kevs1]

Have no idea. Never done an Apple script. I ready to try.

Windows users have better options for this?