Hi,
I have a planner and i am trying to populate my weekly plan from a master schedule. I have included the sheet.
I enter my class info into the class data sheet. I then use dropdown's to fill in the timetable with the required class data, in the required period. This should then populate the planner sheet as soon as the info is entered into the timetable.
In the planner i enter the day (DAY 1) and the date on monday and I want it to auto correct so that for week 1, monday, period 1 that class = 11 SCI (concatenate(timetable(B2, C2)), and room = B8 (timetable(D2))
Hopefully it is clear as mud!
Col
Bookmarks