Hi - hope someone can help.
I've been asked to set up a master table showing student allocations to
different departments on different dates (e.g. Mon-Fri, Jan1st-Dec31st),
where 1st table acts as master table, copying data to other tables in
workbook, and any changes are driven by front sheet only.

Points to consider:

Separate sheet for each of following:
a) Each student requires copy of only their timetable (date/dept./notes etc.)
b) Each Department requires copy of which students are coming
(date/student/notes etc.)

Plan needs to be adaptable to be copied out for each new yearly intake.
Front sheet to colour highlight different departments, to avoid unnecessary
over allocation of students

Hope someone can help - maybe from existing educational establishment.

I have some ideas as to how I envisage this working, yet am frustrated by
lack of knowledge to put it into practice in spreadsheet.

Regards, in keen anticipation,
Woody