View Single Post
 
Old 04-03-2014, 03:04 AM
ali212006 ali212006 is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Mar 2013
Posts: 3
ali212006 is on a distinguished road
Default HELP - comparing spreadsheets in excel 2010

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
Reply With Quote