Drop Down Lists
 

Hi All
In Column C row 5 I have a drop down list of the cities in the United Kigdom
in Column C row 6 I have a dropdown list of World Countries
Is it possible to change the drop down list of C5 if I change the Country in
C6 drop donw list?

Thanks for Looking

Stew

Drop Down Lists
 

hi
yes it is. it's call cascading combos or dependent combos.
see this site
http://www.contextures.com/xlDataVal13.html

regards
FSt1

"stew" wrote:

Hi All
In Column C row 5 I have a drop down list of the cities in the United Kigdom
in Column C row 6 I have a dropdown list of World Countries
Is it possible to change the drop down list of C5 if I change the Country in
C6 drop donw list?

Thanks for Looking

Stew

Drop Down Lists
 

Thank you

stew

"FSt1" wrote:

hi
yes it is. it's call cascading combos or dependent combos.
see this site
http://www.contextures.com/xlDataVal13.html

regards
FSt1

"stew" wrote:

Hi All
In Column C row 5 I have a drop down list of the cities in the United Kigdom
in Column C row 6 I have a dropdown list of World Countries
Is it possible to change the drop down list of C5 if I change the Country in
C6 drop donw list?

Thanks for Looking

Stew