I am posting this separately from the Lablogger Timetabling thread as it would keep things together as the plan is to show and guide folks how to use this for their own needs following feedback from the other thread. Let me stress at the outset that I am in process of migrating all out stuff to Lablogger as the time to do this is far less than writing the coding to have the spreadsheet do stock checks against requests ! We originally has each teacher submitting separate and diverse spreadsheets for the poor Tech to transfer onto the master.....took at least a couple of hours and prone to error. So I developed my own spreadsheet (attached) where the Master (mine) gets populated from each teachers' sheet. The teachers do not need to type anything and use drop-down lists to select Room, Year, Lesson and the sheet automatically populates the equipment requirements for that lesson. This then populates the master so I get a complete view of the week, days and periods. I am happy to share this and guide people with how to use it for their own needs if not using Lablogger. It is straight-forward, but at times can be a bit 'Excel-ly" and some things have to be done in a certain way for it to work properly. My plan is to extend this thread with "How to...." guidance (probably separate Word documents) so that folks have a reference. Here's the file. You have to enable macros when asked. There is one in the workbook which clears all entries on the teacher sheets when they make a change to the Year group, etc. Please feel free yo have a play with it and let me know what of the "How to...." you'd like first. I have no plans to develop this any further so you'll have to take it "as is". Enjoy. And have a great weekend !!