Hi everyone,
Needing some expert help! I've been asked to help out with the printing of the staff timetable as our person in charge had previously used Nova T4 to print the all staff timetable and it is now unavailable. We would like to be able to sort the staff by department and then print so that the output is something like
Page 1 shows the week 1 timetable for each member of staff teaching Chemistry, Physics, Biology
Page 2 shows the week 2 timetable for each member of staff teaching Chemistry, Physics, Biology
Page 3 shows the week 1 timetable for each member of staff teaching History, Geography, Maths
Page 4 shows the week 2 timetable for each member of staff teaching History, Geography, Maths
and so on. Is this possible or is there a more straightforward way of doing it than exporting into excel and manually moving columns, formatting cells etc
Any help would be much appreciated!