Using lists to display timetables
Hi,
I’ve created a timetable to track student lessons at my school (what subject and which staff – selected from lists) I have all students tracked on the same table, and a sheet for each day of the week (eg Mon – Fri)
what I’d really like to add now is a sheet where I can select a students name from a list, and generate a full week timetable just for that student. I’ve tried to work out how to do that, but I’m struggling!
if possible I’d then like to do the same for staff members to show which lessons and students they’re supporting – but think that may be more difficult!
Happy to attach where I’m up to if it helps!
Hi,I’ve created a timetable to track student lessons at my school (what subject and which staff – selected from lists) I have all students tracked on the same table, and a sheet for each day of the week (eg Mon – Fri)what I’d really like to add now is a sheet where I can select a students name from a list, and generate a full week timetable just for that student. I’ve tried to work out how to do that, but I’m struggling!if possible I’d then like to do the same for staff members to show which lessons and students they’re supporting – but think that may be more difficult!Happy to attach where I’m up to if it helps! Read More