Comparing spreadsheets

[Gabe]

I am to compare spreadsheet A to spreadsheet B to find out
what B is missing from A.

Any suggestions to function I could use to do this?

 

[Max]

How about trying Myrna Larson's and Bill Manville's Compare (an add-In
utility):
http://www.cpearson.com/excel/download.htm

 

[Gabe]

Thanks... But Ms. Larson already wrote to me indicating
that the file mentioned would not work for my particular
problem. It matches formulas and such... I have names and
personal information on my spreadsheet. Thanks.

 

[Dave Peterson]

Do you have a key column in each worksheet that can be used to compare what's
there and what isn't.

If yes, then you could use =isnumber(match(a1,sheet1!$a$1:$a$9999,0)) in a
helper column in sheet2 and =isnumber(match(a1,sheet2!$a$1:$a9999,0)) in sheet1.

Adjust the ranges and the sheet names and copy down. You'll see a bunch of
true/false's. Trues mean match.

This'll work ok if your lists have that unique key. If you wanted to compare
values in adjacent cells for each key, you could use a series of =vlookup()'s to
return the associated values.

 

[Max]

Its amazing that Myrna pre-empted the workability of her add-in to your
situation purely based on your original post's description <g>..

Just another 2 cts worth.

Browsing through a google search brought up the "Operis Analysis Kit" in:

http://www.operis.com/oak.htm

which claims a relevant feature:
-----------------
OPERIS ANALYSIS KIT FUNCTIONALITY

Compare Worksheets: this function aligns the structural blocks in two
similar worksheets and compares the aligned worksheets on a cell by cell
basis: