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

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