Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get Excel to flag the need for recurring updated data?
We have forty peole who need to supply us with ongoing data which we enter
regularly. Some of this data is periodic and need to be updated at regular intervals. Some data needs to be updated every six months, some every two weeks, some quarterly. Can Excel be set up to flag us a month early so that we may request updated data? Can it be done for 40 or nore users? We are using Office 2003. Rich gepc |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get Excel to flag the need for recurring updated data?
"gepc" wrote in message ... We have forty peole who need to supply us with ongoing data which we enter regularly. Some of this data is periodic and need to be updated at regular intervals. Some data needs to be updated every six months, some every two weeks, some quarterly. Can Excel be set up to flag us a month early so that we may request updated data? Can it be done for 40 or nore users? We are using Office 2003. Rich gepc You can use conditional formatting to change the background when something needs to be entered. An alternative is to have a macro that runs whenever you open the sheet that checks the date and tells you what data you need to request. http://spreadsheets.about.com/gi/dyn...s%2F000351.php /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel cells randomly don't get updated unless each cell is updated | Excel Discussion (Misc queries) | |||
How do I flag up duplicate data entry in an excel spreadsheet? | Excel Worksheet Functions | |||
How do I enter updated data into Excel worksheet? | Excel Worksheet Functions | |||
How can I get Excel to flag the need for recurring updated data? | Excel Programming | |||
Rows to be moved from one flag to another flag | Excel Programming |