Selecting data from two different columns and rows and making a new calendar

[Mollybop]

Hi!

(THIS IS MY FIRST FORUM POST!)

I have been making a schedule for school, we have two terms running concurrently with multiple disciplines, instructors, rooms, and lessons.

I have 3 sheets that are important:

• T1T4-Actual Calendar with drop boxes that connect to the class list, including the room number, instructor, showing both terms at once so I can check any room or instructor conflict, with buttons two hide one term so I can export each schedule separately for students and staff
• C1C4-Class list where data will updated and changed
• Indiv Sched- (and I dont know what the best way to do this is) ideally I would like to be able to select an instructor and then have a formula check each day, each block (morning, afternoon, and evening) for their name in both terms so that they can have a schedule with only their classes. I cant figure out how to do this. If theres a smart or a long way I will take it, even if it means having a sheet for each instructor thats totally fine. Or copying a formula into each cell....anything that allows me to print off a 7 column/day calendar with the classes they teach from both terms in one document.

I would rather not simply hide or dim the others because when you print the calendar 14 columns across it makes the font really small and I think people will be confused.


It's a bit messy because I had a deadline while I was making it so as new data was being entered I didn't clean up the tables and conditional formatting as I would like.




https://www.dropbox.com/s/gh15e3k1evo4l1i/Calendar Work book .xlsm?dl=0