DreamerROC
New Member
- Joined
- Oct 21, 2017
- Messages
- 1
Hello Everyone,
I am a teacher and my school timetable changes weekly. I am trying to write a formula to check that my timetable does not clash with other classes. I teach accounting. There is a master timetable with all the subjects for one group of students, then the subject timetable are extracted from there and appear on the worksheets that follow the master sheets.
For my subject the master timetable says ACC for accounting. The subject timetable says G1 and G2 for group 1 and group 2 classes. The master timetable corresponds to the cell references on the subject timetables.
Here is the link to timetable:
https://1drv.ms/x/s!Aq3sBqqA2N8xoT4oXpNuqpCJduh1
PS. I do not know how to attach it here.
I am a teacher and my school timetable changes weekly. I am trying to write a formula to check that my timetable does not clash with other classes. I teach accounting. There is a master timetable with all the subjects for one group of students, then the subject timetable are extracted from there and appear on the worksheets that follow the master sheets.
For my subject the master timetable says ACC for accounting. The subject timetable says G1 and G2 for group 1 and group 2 classes. The master timetable corresponds to the cell references on the subject timetables.
Here is the link to timetable:
https://1drv.ms/x/s!Aq3sBqqA2N8xoT4oXpNuqpCJduh1
PS. I do not know how to attach it here.