Help with dates in drop down menus

[sir_glen]

Hi everybody. Im not that great with excel (im only 17 and have no nee
to use it) and I'm looking for some help. I was set a task in my IC
class which was to create a spreadsheet that could be used by a trave
agent. So far I've come up with the file I have attached. My teache
says I've gone beyond what I need to do but there were a few things
couldn't work out and they are really bugging me!

Firstly. If I select say September for the month and 30 for the date
when I change the month to february the date will stay as 30 eve
though I have it set so that only dates upto 28 can be selected.

Also. I want to make it so that if you select a cetain hotel th
destination and number of stars will automatically be filled as well a
adjusting the spreadsheet so that if you select say 3 stars for th
hotel type only destinations with 3 stars will be selectable as well a
only the 3 star hotels.

For some of that I don't have the data organised properly in some o
the sheets but any pointers would be grealy apriciated!

Thanks.

Gle

+-------------------------------------------------------------------
|Filename: Holidays.zip
|Download: http://www.excelforum.com/attachment.php?postid=2675
+-------------------------------------------------------------------

 

[icestationzbra]

most people around here are not too keen on opening attachments, wit
good reason.

its always sapient to provide the layout of the data and details i
verbose mode. you would get help faster that way

 

[Dave Peterson]

sapient (sâ´pê-ent) adjective
Having great wisdom and discernment.

(Now I can agree <bg>.)

 

[Dave Peterson]

I don't open attachments either, but you may want to look at how Debra Dalgleish
used dependent lists with her Data|Validation examples at:

http://www.contextures.com/xlDataVal02.html