School Timetable in MS Excel
Posted on 2010-01-08
I am done surfing for a simple school timetable. My grandson has asked me if I can produce a timetable in MS Excel. As a grandfather, I quickly said yes to his question and produced it, but what happens next year when he asks me again, I thought. Why not produce a timetable as an array and get it to populate the table automatically.
The key data being days Mon - Fri inclusive and 5 periods per day plus the subjects, tutor and room.
I have tried but cannot find the solution. So I wondered if you excel genii could assist please.
I upload the file for your perusal, hoping you may assist me.
Worksheet LEGEND has all the array data. DESIRED OUTPUT is the desired output.