Thread: Dropdown Menu?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
zoran144 zoran144 is offline
external usenet poster
 
Posts: 2
Default Dropdown Menu?

Hi,

This is driving me a little insane.... :) so please help.

Ok here's the setup: I have 3 columns - 1st being the states, 2nd column
shows cities in those states, and 3rd has climate zone values.

Some states have 3 cities some 55...

Alltogether i have over 700 cities...


1. I want to select a state from a drop down menu (this i know how to do)
2. Next I want to select a city but I want to have a drop down menu that has
only cities within the state selected;
3. and last i want to display the climate zone value for that selected
city....

Thanks a million!