| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
freezing cell values
can any one please advise.
I want to record over a six week period the number of hotel bookings. so in week 1 I will show bookings received for week 1 plus weeks 2 -7. how can I freeze snap shot values for the individual weeks so that as the weeks progress I can still look back and see the state of bookings as they were in any particular week the object being to measure how far ahead people are making bookings in different parts of the year. |
|
#2
|
|||
|
|||
|
Have 3 date fields...
Reservation Date Start Occupancy Date End Occupancy Date This will allow you to create stats such as Length of Stay, # of days booked in advance, Season Length of Stay, etc. HTH, -- Gary Brown "anthony" wrote: can any one please advise. I want to record over a six week period the number of hotel bookings. so in week 1 I will show bookings received for week 1 plus weeks 2 -7. how can I freeze snap shot values for the individual weeks so that as the weeks progress I can still look back and see the state of bookings as they were in any particular week the object being to measure how far ahead people are making bookings in different parts of the year. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split cell values based on content | Excel Worksheet Functions | |||
| how can I select two different values for a cell? | Excel Worksheet Functions | |||
| limit choice in cell to one of two values; | Excel Discussion (Misc queries) | |||
| Freezing a cell range | Excel Discussion (Misc queries) | |||
| Stumped! Collecting values into one cell. | Excel Worksheet Functions | |||
Linear Mode
