Need Calendar to Populate from Schedule using multiple criteria

Hi there,

If you look at the attached example, I need help auto-populating calendars with the information in the Schedule tab.

There are two calendars in each classroom tab as the class can be either a 1 or 2 day session (Schedule Tab Column B). Leveraging the Schedule tab, I need the calendars to be able to block conditional format for the time slots.

For example, in the schedule tab, line 2 and line 4, in the Room 110 tab, have calendar that is labeled "2 day class" be able to block off that time slot using column B from the Schedule tab. Therefore do the same for line 4, however would populate calendar labeled "1 day class".

If the number of days in column B is not specified, do we assume it to be 1 day?

If it is 2 day, then does this mean you want the next day to be highlighted, e.g. if the day is Wed and 2-day, do you want Wed and Thu highlighted in the 2 calendars?

You should format columns F and H as General to see the correct hour.

It would help to put the room number in each sheet, e.g. in cell A1 or I1.

I would suggest having a helper column in the schedule sheet which will identify the room number, time-slot and whether 1- or 2- day.

I'm about to go out now, but I'll check for your reply when I get back (several hours).

Hope this helps.

Pete

John, The 1 and 2 are identifiers for which calendar it populates. It should only highlight the day and time slot pulled from the schedule. So, looking at line 2, the 2-day calendar in tab Room 110 should only highlight the Mon column for the time slot 10:05AM—11:00AM. I think your current macro is highlighting Mon and Tues assuming the 2 days?

When I update the schedule and click run, the calendars don't update.

One last ask and this will be the perfect template: Can you stop the Schedule tab from re-sorting every time I hit the macro button?