Reservation Availability Workbook

Retiredndakota

New member
Joined
Sep 11, 2012
Messages
2
Reaction score
0
Points
0
Location
South Dakota, USA
I'm working on a workbook that I created many years ago.
I'd like to add an availability workbook that looks into existing workbooks and future workbooks for date data.
An example of the desired look is included as a sheet on the attached workbook.
Once a customer calls I need to look at availability and book accordingly.
I only have one property that's used for extra income during retirement. Ha Ha


Thanks

Barry


View attachment Planes Place Statement (2).xlsm
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
You should change the AVAIL sheet to not be coloured but to have a value saying say R(eserved), N(ot Available), or blank (Available), and use CF to colour based upon those values. Have a flat table of dates and values as well and then you could do a simple lookup based upon the dates being requested.
 
Top