School Timetable in MS Excel

Posted on 2010-01-08
Last Modified: 2012-05-08
Hi experts
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.
Question by:tezza73

    Author Comment

    oopps forgot the file
    LVL 12

    Accepted Solution

    Here you go.  I did Monday and Tuesday for Period 1.  See if you can fill in the rest.


    Author Closing Comment

    Managed to fill in the other cells. Nice way to teach and the pupil (this side) learned from his tutor.
    Thanks a lot
    LVL 12

    Expert Comment

    You're welcome.  Thanks for the grade!


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Suggested Solutions

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now