Quote:
Originally Posted by Claus Busch
Hi,
Am Wed, 12 Mar 2014 00:38:15 +0000 schrieb trangnguyen:
1 Megan Davis Convention Center p49 fig 2
2 Daily Meeting Room Rates
3 Code Meeting Room Advance Rate Standard Rate Special Rate
4 AU Auditorium $2,418.75 $2,925.00
$1,735.00
5 BD Boardroom $1,912.50 $2,550.00
$1,330.00
6 CF Conference Center $2,475.00 $3,200.00 $1,900.00
I would try it with dependent data validation.
Have a look:
https://onedrive.live.com/?cid=9378A...121822A3%21326
for the workbook "RoomRates"
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|
HOW CAN I TRY IT WITH COMBO BOX UNDER FORM CONTROL AND USE VLOOKUP, NESTIF TO FIND THE TOTAL?