Drop Down lists

[Mike]

Does anyone know if and how I can create a drop down menu who's contents are based on the selection of another drop down menu.

For example the first drop down menu is a list of US states and the second is a list of cities that is based on the state selected.

 

[Debra Dalgleish]

If you want dropdown lists in a cell, you can use dependent data
validation lists. There are instructions here:

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

 

[Gord Dibben]

Mike

See the excellent help(with pictures) at Debra Dalgleish's site.

http://www.contextures.on.ca/xlDataVal02.html

Gord Dibben Excel MVP