Auto updating calendar in excel
I have created an excel spreadsheet with deadline dates for expiration for each truck.I was wondering if there was a way for excel to automatically send alerts to Outlook letting me know 30 days in advance when these dates are coming up. It sounds like it can be done, but I can never get a final outcome.Hello, I work for a utility company with over 300 pieces of equipment.It is hard to keep track when everyone needs to renew their tags, licenses, and get lift inspections.While Excel shines easily when you want to log this data, it has no quick way to visualize this information.But we can use little creativity, conditional formatting, few formulas & 3 lines of VBA code to create a slick, interactive calendar in Excel. As you may know, I am running my first ever Advanced Excel & Dashboards Masterclass in USA this summer (May / June 2013).The cycle is the same each year, but the actual dates differ from one year to the next...presently, I re-do the calendar by entering Jan 1, 200?
If you live near any of these cities and want to become awesome in Excel, please consider enrolling in my Masterclass.) instead of just filling down the workdays and workdates......