Display Room availability per month from drop down

[vacances_2000]

HI
Well can 't see where i can send any attachement with this treat. So let me try to explain.

In worksheet 1 I do have my guest list and in worksheet 2 i do have my availability overview which is now only for JANUARY... I have created in the same sheet a drop down box with the 12 months of the year but now what I want is:
> How can you make the drop down list work so that when you select a month you get that month on the same sheet and not have to create 12 different sheets? I presume that when this is done whenever filling in the guest list with a check in date from a month ahead this will also be automaticly filled in on the same sheet....

Thanks so much for your help!

Jonathan

 

[jc.021286]

Hi there Jonathan,
Welcome to the board,

From my understanding, you have a validated list where if you change it, you wish to pull up a reference table for an entire month. From my understanding of the booking industry, you would probably want to pull in a table where dates go across the top and the rooms are down the left side.

Then, displayed inside would be a matrix of Yes, no, or Reference IDs for people that are staying in a given Suite on a specific day.

How would you want to enter data into this spreadsheet? Or would you be looking to have a few drop downs, 1 where you select the Month, the 2nd drop down is updated from the first showing the available rooms/and/or dates. Where a person could then enter in the customer details and allocate them that spot?

So many ways to go about doing this. We could even get it so that everything is displayed in nice Userforms and display boxes for a better User Interface.

Let me know,
jc

 

[vacances_2000]

Hi jc!
Indeed bit of what you guessed! It has to be a table where dates go across the top let's say D4 : AE4 and the rooms are down on the left side from B3 till whatever supposing you will always be able to add new rooms if expending. In the top left corner A1 comes the only drop down (the one where you can pick the month you are looking for) for the whole sheet (on sheet2).

Enter the customer details is on sheet 1 where the person will fill check-in and check-out date etc.. This data will trough a formula be transfered to sheet two to complete the availability overview.

See this link for more understanding. Just see the month drop down what I mean... The rest I already made my own formula and layout...

http://exceltemplate.net/calendar/booking-calendar/

If you don't get it, how can I send you my excel file?

Thanks
Jonathan