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