Create Schedule from Calendar Data

[skagit07]

Hey everyone, I've got some data based on a short term class schedule. I'd like to figure out a way to turn this data into a calendar format in excel, where the date, start time, and duration of the class automatically create a window to be blocked off on the calendar so no other class can accidentally be scheduled there. It's easy enough to do manually, but this is just a small example of the schedule, which is really about 20 times the scale. Also, when I change the data in Cell A2, I'd like the calendar to update to show that day.

Any suggestions?

Thanks!!
Justin

[JohnTopley]

Please Login or Register  to view this content.

Sheet code: right click on tab Sheet3>>View Code>>> Copy/paste above code

Please Login or Register  to view this content.

In genreal module (Module1)

Change sheet names as required

CHANGING date in A2 (Sheet3) will invoke update of the calendar.

Added CLASS to list in Sheet4

[skagit07]

Thank you so much for your reply. I've updated the sheet names but for some reason changing the date in cell A2 is not updating anything. Any advice for that?

[JohnTopley]

Did you add the first macro to "Sheet3 "(or its equivalent in your file): from my post ......

Sheet code: right click on tab Sheet3>>View Code>>> Copy/paste above code

[skagit07]

Yes it seems to be working now. Thanks for all your help!