I'm really new to excel, but was tasked with creating a reservation sheet for our Aquatics Community Center. It has 3 work sheets where one is supposed to be able to enter basic information about reservations for different rooms. On the last sheet is a visual table of the date, the room and the hours and this is supposedly to show the the availability of the rooms and is supposed to fill it self out automatically, based on the information you enter into the first three worksheets.
Please look at my worksheet (BOOK 1) and the template (COPY OF HOTEL RESERVATIONS) that I am basing it on to get a better picture.
I tried to create a nested function that would fill a cell with the values of 0,1 or -1 depending on whether certain variables were true or false. I was then intending to format the cells conditionally to turn a different color based on the number.
This is the code that I used:
The AND function is supposed to relate to the room type and the date of the booking. The SUMPRODUCT.... well to be honest I'm not really sure. I tried to modify the code that was used in the template I looked at and I researched it as much as possible, But I'm still struggling to understand.Please Login or Register to view this content.
If someone could please try and help me out, I would really appreciate it.
I'm also not sure If I've posted all the information need, so if anything else is require, please just let me know.
Thanks
Bookmarks