|
|
#1
04-03-2014, 03:04 AM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Copy Column setting to other spreadsheets in an excel workbook | officeboy09 | Excel | 5 | 11-05-2013 01:49 AM |
 Can't open spreadsheets
|
kaygeea | Excel | 7 | 10-05-2011 08:00 AM |
|
Odd Excel problem when 2010 spreadsheets
|
uchacker11 | Excel | 1 | 08-01-2011 04:24 AM |
|
Merging two spreadsheets
|
BrazzellMarketing | Excel | 5 | 04-26-2011 01:51 PM |
| PWA, sharepoint links, and spreadsheets | Rkramkowski | Project | 0 | 06-21-2006 01:29 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode