• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel 2013 Notifications?

olds

olds

Elite Member
I want to set "15 day" and "Due"automatic reminders from an Excel sheet. Preferably by email.

IE:
I have an assignment that is tracked by a number and all assignments must be completed within 30 days of the Evaluation Date.

So I enter the assigned "Evaluation Date" in a cell: 4//2016.

I'd like to get automatic notifications after 15 days and then again on the due date.

I'd also like to be able to turn off the notifications by entering a date in a cell called "Completion Date".

Is this possible?
 
There are a number of ways to do this. Email is easiest if you have Outlook configured, otherwise it could be a little bit of work to use another email system.

Do you open this file daily? If so it may just be easier to have a pop up summary or something of that nature when you open it. If not, you can set windows tasks to execute macros in the workbook on set schedules.
 
Thanks. it wouldn't be open daily, it would have to run in the background. Or I could just never close it if needed.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top