LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
PK PK is offline
external usenet poster
 
Posts: 69
Default automatic alerts in excell

I am responsible for peoples training therefore I am required to monitor when
refreshment courses are due. For this I would like to create an excel dtabase
in to which I can place a date in one cell and then when a set periods has
passed I am informed that a refresher is due.
for example.
E3 may contain the date for which an individual first attended a course
i.e. 21st Oct 2007.I the would then like cell F3 to show 'Refresher Due' once
12 months had passed. In the mean time I would like cell F3 to be blanc. I
realise that I may have to have a Cell, A1 for example with 'todays date' in
to give F3 a reference.can this be done?
Thank you for your help.
--
pk
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Email alerts Frank Excel Discussion (Misc queries) 4 February 20th 07 08:35 PM
alerts gambit Excel Worksheet Functions 3 August 22nd 06 04:02 PM
MsgBox alerts Andy the yeti Excel Worksheet Functions 1 January 19th 06 12:50 PM
Alerts? audiophile New Users to Excel 4 December 29th 05 02:16 PM
Automatic page breaks in Excell 2003 Novice Excel Discussion (Misc queries) 2 February 21st 05 09:59 PM


All times are GMT +1. The time now is 10:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"