View Single Post
  #7   Report Post  
trangnguyen trangnguyen is offline
Junior Member
 
Posts: 4
Default

Quote:
Originally Posted by Claus Busch View Post
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?