Drop down list

[flashy]

Is there a way within excel to create a drow down list and have each of the
items on the list have a drop down?

Example
Base
EXT
INT---- 101
---------102
----------103 ect

 

[Jayson]

You can do this with Data Validation. just type the list into the box, or
refer to a range that houses the list

 

[RagDyer]

Sounds like you will want to use "Dependant Lists".

Check out Debra Dalgleish's web pages on the subject:

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

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

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

 

[flashy]

Tried those, they do not allow what I am looking for Any other suggestions?

 

[RagDyer]

You might try posting this question in the programming group.