Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a spreadsheet to calculate and email an alert?
We use a shared spreadsheet to list projects and due dates. One of the
columns contains the start date, and one contains the due date,and several columns contain team member names, but nothing automatically alerts anyone to which projects are at the 50% stage and require a mid-course review. (For that matter, nothing reminds anyone to open the spreadsheet each day and look at it! :-) What would it take to program a spreadsheet to automatically check today's date against all start/due dates, calculate the 50% date, compare that to today's date, and if any projects are at the 50% stage today, generate an email alert to each team member that it's time to do a 50% review for projects X and Y? Or, alternatively, at least whenever anyone opens the spreadsheet on any given day, they at least get *some* kind of alert, pop up message, or bright highlight in the spreadsheet, etc. on any projects that have reached the 50% stage. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a spreadsheet to calculate and email an alert?
Hi JustSomeGuy
You can use a helper column like I use here http://www.rondebruin.nl/mail/folder3/message.htm See example 2 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JustSomeGuy" wrote in message ... We use a shared spreadsheet to list projects and due dates. One of the columns contains the start date, and one contains the due date,and several columns contain team member names, but nothing automatically alerts anyone to which projects are at the 50% stage and require a mid-course review. (For that matter, nothing reminds anyone to open the spreadsheet each day and look at it! :-) What would it take to program a spreadsheet to automatically check today's date against all start/due dates, calculate the 50% date, compare that to today's date, and if any projects are at the 50% stage today, generate an email alert to each team member that it's time to do a 50% review for projects X and Y? Or, alternatively, at least whenever anyone opens the spreadsheet on any given day, they at least get *some* kind of alert, pop up message, or bright highlight in the spreadsheet, etc. on any projects that have reached the 50% stage. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Create Sound Alert and Email Alert when Macro is Finish | Excel Programming | |||
How to Create Sound Alert and Email Alert when Macro is Finish | Excel Programming | |||
How to Create Sound Alert and Email Alert when Macro is Finished | Excel Programming | |||
Email alert to call or view a line in a spreadsheet | Excel Worksheet Functions | |||
triggering an email alert from within a spreadsheet based upon a d | Excel Discussion (Misc queries) |