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 it compares exact cell by cell comparison: A32 compares with A32, C977 with
C977.
So I'm hoping that your boss inserted a few lines, but kept the majority of
lines in the same order.
I'd run Myrna and Bill's addin and look for little changes (individual cells
change).
But sooner or later, you're going to have a row inserted that throws the whole
thing off.
After you find that row (or group of rows) you can insert some blank lines into
that smaller file and start again. (You'd be building up the small worksheet to
match the same number of rows that the larger worksheet had. Then when you get
them with the same number of rows, you run Myrna & Bill's addin for real!)
It might take a few times to find the spots where he/she inserted the 67 rows.
And if the boss deleted rows, it becomes more difficult.
=======
If you have a key column that you can use--no duplicates within each worksheet,
you can insert a column in worksheet and put a formula that says that key shows
up in the other worksheet.
Say your key data is in Column A of each sheet.
Then insert a new column A (in both).
Then put:
=COUNTIF([book1.xls]Sheet1!$B:$B,B1)
Type =countif(
and point at column B of the opposite sheet and have excel get the syntax
correct)
then add
,B1)
and drag down
The formulas that evaluate to 0 mean that they don't exist in the other sheet.
(Maybe you could pick up that set of rows from the new worksheet and paste to
old worksheet.)
And maybe delete those rows that have formulas that evaluate to 0 in your old
worksheet--the boss deleted them!
=======
Either way you do it, it really turns into a messy manual effort. If your
changes were small, it might be better to just bite the bullet and re-do them.
But then tell that only one person can control the workbook at a time. If you
have it, the boss can't update his copy (and vice versa).
