View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mattlynn via OfficeKB.com Mattlynn via OfficeKB.com is offline
external usenet poster
 
Posts: 140
Default 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