Hi everyone,
I've been casually using excelforum for a while now with basic queries but I dont think this one has been answered (I've searched around for a while!). Thank you for your patience - this might be me asking for too much, but hopefully, you'd be able to let me know if it is...
I work for a library service which has 6 libraries and each one has a handful of rooms available to hire. We also run internal classes in these rooms. Currently, we use a set of VERY basic spreadsheets (one per branch) I splashed together, to book in classes and external hirers. Can anyone suggest a better spreadsheet that could be more user friendly/clearer/less prone to mistakes? Currently, we're just selecting cells and merging them between the hours of a room booking (please see attachment).
It would be great if we could simply ahve a dropdown option for start time and end time and a way to indicate other details such as cost of booking, details of the hirer etc.
To complicate things further... We also make a weekly lab display that ties into this spreadsheet. So once the bookings are taken, staff then create a display for the public to know what bookings are taking place in each room. It would be amazing if this could be fed in from the lab booking spreadsheet.
Does any or all of this sound plausible? My excel knowledge is incredibly basic, but I have lots of time (as this is kind of a pet project) so I'm willing to learn or follow a step by step guide.
Thank you SO MUCH for giving your time to read this and for any suggestions!
-Uzbuzz
Bookmarks