Worksheet Alerts
 

We have case reviews that are driven by the Birthdates and Ages of our
children. Is there a way to have excel notify you when a child has a
birthdate (review) due?
We have hundreds of children to monitor and to scroll through data is too
time consuming. Are there pop-up alerts or a way to set conditions to notify
us.

Worksheet Alerts
 

You could build a pivot table around the month element of the birth date.
This would identify the children who birth datesare due in the current month.

Matt




csd1126 wrote:
We have case reviews that are driven by the Birthdates and Ages of our
children. Is there a way to have excel notify you when a child has a
birthdate (review) due?
We have hundreds of children to monitor and to scroll through data is too
time consuming. Are there pop-up alerts or a way to set conditions to notify
us.

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1

Worksheet Alerts
 

Have you thought about using a different application.

Google has a web based calendar program that you can use to send emails or
popups. You can share the calendar with others, too.

http://www.google.com/calendar




csd1126 wrote:

We have case reviews that are driven by the Birthdates and Ages of our
children. Is there a way to have excel notify you when a child has a
birthdate (review) due?
We have hundreds of children to monitor and to scroll through data is too
time consuming. Are there pop-up alerts or a way to set conditions to notify
us.

--

Dave Peterson

Worksheet Alerts
 

I don't know what your worksheet layout is, so play about with this:
I created a dummy worksheet
A1 = "Child"; B1 = "Birthday"
A2 = "child 1"; B2 = "23/12/1979"
A3 = "Child 2"; B3 = "06/10/1981"
A4 = "Child 3"; B4 = "30/11/1983"
..
..
..
now add in column C:
C1 = "Birthday next month?"
C2 = "=IF(MONTH(B2) = MONTH(NOW()+1),"Yes","")"
Drag C2 over C3 to end of column (in this case C4)
Today is still in September so C2 & C4 are empty; C3 = Yes.
If you don't find this reply till Weds next week, C2 & C3 will be empty and
C4= "Yes"
Autofilter on "Yes" in column C to finf all children with birthdays next
month.

"csd1126" wrote:

We have case reviews that are driven by the Birthdates and Ages of our
children. Is there a way to have excel notify you when a child has a
birthdate (review) due?
We have hundreds of children to monitor and to scroll through data is too
time consuming. Are there pop-up alerts or a way to set conditions to notify
us.

Worksheet Alerts
 

Oops, Formula should read:
"=IF(MONTH(B2) = MONTH(NOW())+1,"Yes","")"

"Lionel H" wrote:

I don't know what your worksheet layout is, so play about with this:
I created a dummy worksheet
A1 = "Child"; B1 = "Birthday"
A2 = "child 1"; B2 = "23/12/1979"
A3 = "Child 2"; B3 = "06/10/1981"
A4 = "Child 3"; B4 = "30/11/1983"
.
.
.
now add in column C:
C1 = "Birthday next month?"
C2 = "=IF(MONTH(B2) = MONTH(NOW()+1),"Yes","")"
Drag C2 over C3 to end of column (in this case C4)
Today is still in September so C2 & C4 are empty; C3 = Yes.
If you don't find this reply till Weds next week, C2 & C3 will be empty and
C4= "Yes"
Autofilter on "Yes" in column C to finf all children with birthdays next
month.

"csd1126" wrote:

We have case reviews that are driven by the Birthdates and Ages of our
children. Is there a way to have excel notify you when a child has a
birthdate (review) due?
We have hundreds of children to monitor and to scroll through data is too
time consuming. Are there pop-up alerts or a way to set conditions to notify
us.