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
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"flashy" wrote in message
...
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