Automatic calendar update

Hi I am looking to get some help with excel but don’t know how to word my question.

I am trying to create a calendar that updates itself. I will do student enrolments for my business and I want to be able to fill in the names of students that I enrol (on the Enrolments calendar which is sheet 1) and then the calendar should automatically take that name and fill it in on Sheet 2’s calendar. It should be the same date but 3,6 and 9 months after enrolment. (So that I can keep track of which students require their reports)

So if I enrol Josy on 4th of Jan, then I type it into calendar on sheet 1 then excel takes that name and places her name on 4th of April of Sheet 2’s calendar (and add text saying “3months”or add a colour change so that I can distinguish between 3,6 and 9 month reports) and it does the same for 6 and 9 months.

Ultimately I want to be able to type in my enrolments and Excel to automatically tell me when those students are due a 3,6 or 9 month report?

Please Please help 🙂

Kind regards


By: Melissa

Leave a Reply

Your email address will not be published. Required fields are marked *