Help with generating automatic email when "status" changes to past due

[cassie4258]

I need to do several things with this spreadsheet, and I'm not nearly familiar enough with the coding part to figure it out. Help will be much appreciated... especially with the email portion.

1.) I made a calendar macro (smiley face at top of spreadsheet) to fill in the "date" cells, but I would like it to pop up automatically when someone clicks in one of those boxes.



2.) I need the "number of days past due" to automatically calculate as a running talley when set to "past due" status

3.) The "tip" note doesn't pop up for every date blank like the "employee" one does, just the first cell at the top of column does.

4.) For the email portion, I would like Excel to send an email to the selected employees reminding them when the "status" flips to "past due"... and then at a regular interval afterwards, say once a week. Also wondering if there is a way to copy a supervisor on every past due reminder that is sent.

Thank you all in advance!