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