| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
See Changes in Worksheet Submitted Weekly
Similar to 'track changes' in Word idea - - -I have 6 Reps that submit a
worksheet to me weekly, and I'm only interested in the data that changes from one week to the next. Is there a way in Excel to compare a sheet to the previous week's and have it shade/note the changes? If not, any suggestions for how I might make this easier on them and myself - other than having them shade the cells they alter? As always - thanks much - this is a GREAT site! -TexJen |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
See Changes in Worksheet Submitted Weekly
on the version of Excel I am using , there is an option on tools/track
changes to see what has been updated "TexJen" wrote: Similar to 'track changes' in Word idea - - -I have 6 Reps that submit a worksheet to me weekly, and I'm only interested in the data that changes from one week to the next. Is there a way in Excel to compare a sheet to the previous week's and have it shade/note the changes? If not, any suggestions for how I might make this easier on them and myself - other than having them shade the cells they alter? As always - thanks much - this is a GREAT site! -TexJen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weekly report | Excel Worksheet Functions | |||
| How can I view the posts I have submitted? | Excel Discussion (Misc queries) | |||
| calculating b-weekly pay | Excel Discussion (Misc queries) | |||
| with weekly score sheet how do I column a weekly progressive aver. | Excel Worksheet Functions | |||
Linear Mode
