Hi i have 2 spreadsheets with the same information which is updated ona weekly basis. New rows are added but the sheets ae sorted in alphabetical order so you can never identify which rows are new or have been amended.

Basically I want to compare the last report with the current report. I want to highlight which rows are still the same and which rows are new.

Can anyone help - I am on deadline with this and its taking me forever to eyeball the docs. There are over 5000 rows. I could cry!!!

thanks in advance

Simply use a formula on a third sheet that does a cell-by-cell comparison:
=Sheet1!A1=Sheet2!A1
then copy down & across as far as needed.

This will return TRUE for any that are the same and FALSE for any that differ, not just whether the rows are 'new'.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]