Hi,
My table is consist of a hotel rates example can be seen in picture below. My requests (seems extremely far from my skills at the moment) can be compiled as in the following:
• Is there a possible formula (or vba) to auto populate the criterias (the first 3 needed to be populated) related the datas on table?
• What can be the formula (or vba) to obtain the appropriate price at TOTAL box regarding the criterias selected beforehand?
Thanks in advance for your valuable helps.
Price Table.jpg
Bookmarks