Cells carrying over data in perpetual booking calendar month by month

I have tried to put together a Room Booking spreadsheet, however when I write a name etc. into a cell within the booking area it will stay in the same cell when I change the month. (file attached) I would like it to come up with a fresh month each time. How could I do this?
Cheers

Hi Jeff,
thanks for working on this issue, however when I input information into month X, then skip forward and input info into month Y, once I skip back to month X all the information is cleared. Is there a way to retain the information for the years bookings?
cheers

Sorry, I am misunderstanding what you want. What does this mean? What exactly do you want to happen when you change the month?

Originally Posted by Computersaysno

I would like it to come up with a fresh month each time.

when I put bookings into January and leave to put a booking into March that that when I return to January the booking will still be there. The current fix does not give me that ability. (fresh month moving forward but retain info when moving back)

Maybe you should have a separate bookings sheet, on which you can record (in any order) the date, time and Name for the booking(s) - you could have a helper column to join this data together, and there would need to be some alert feature to ensure that a particular time slot is not being double-booked. Then the information could easily be displayed on the Education Room sheet by means of an INDEX/MATCH/MATCH formula.

Can you provide some examples of the types of bookings that you would want to see logged, then I can take a look at it tomorrow (as it is getting late here).

Hope this helps.

Pete