Hi all,
Please, please help. This is actually driving me nuts. I have attached the document below. I want to make a timetable solution for the tuition service i work for. My Excel skills are limited (hence asking this question) but if I can get this spreadsheet to work it would be perfect for our service.
As an example, when ICT is selected in "Pupil A" on a day/time I want that pupils name to populate one of the four slots for that day/time on "Teacher A (ICT)". Is that possible? Of course, if it works, if Science is selected it will populate another sheet called something like "Teacher F (Science)".
Of course there will be other pupils/teachers so if the 1st slots filled the pupils name will populate the 2nd, etc. We only teacher small groups of 4 max.
schedule.xlsx
Bookmarks