Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reservation system
Howdy,
I´ve got a small guesthouse, and use the excel to manage the bookings. In sheet one, I type the following: Cell a: date of arrival Cell b: date of departure Cell c: total number of days Cell d: name cell e: if double room, type number of rooms here cell f: price of the double room Cell g: if single room, type number of rooms here cell h: price of the double room cell i: number of extra beds, if any cell j: price of the extra beds cell k: total price Sheet number two Based on cell a and b, from sheet one, and how many rooms, than I manually type here what dates are booked. This gives me a quick overview, how many rooms are taken, or free, and can therefore give a quick reply to the customer waiting in the telephone. My question is: Is there a function, that could take the data from sheet one, cell a and b, and put it correctly in sheet two, ie give me a fast overview. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reservation system
Hi Beautrux,
Have you tried to link the cells using the link function. Kerry "Beautrux" wrote: Howdy, I´ve got a small guesthouse, and use the excel to manage the bookings. In sheet one, I type the following: Cell a: date of arrival Cell b: date of departure Cell c: total number of days Cell d: name cell e: if double room, type number of rooms here cell f: price of the double room Cell g: if single room, type number of rooms here cell h: price of the double room cell i: number of extra beds, if any cell j: price of the extra beds cell k: total price Sheet number two Based on cell a and b, from sheet one, and how many rooms, than I manually type here what dates are booked. This gives me a quick overview, how many rooms are taken, or free, and can therefore give a quick reply to the customer waiting in the telephone. My question is: Is there a function, that could take the data from sheet one, cell a and b, and put it correctly in sheet two, ie give me a fast overview. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I create a reservation book for a small hotel? | Excel Discussion (Misc queries) | |||
system recovery | Excel Discussion (Misc queries) | |||
How can I create a reservation chart for hotel guests? | Excel Discussion (Misc queries) | |||
File Reservation | Excel Discussion (Misc queries) | |||
excel causing system to be in low system resource | Excel Discussion (Misc queries) |