how do I get one dropdown menu to trigger another one in excel
 

is it possible to have one drop down list affect which drop down list comes
in on the next row? For example, my first drop down defines a type of
machine, so you would select which type of machine you need. then if you
select, say a model 400. the next drop down list would only display parts
applicable for the model 400.

how do I get one dropdown menu to trigger another one in excel
 

Debra Dalgleish shows how using data|validation.

http://contextures.com/xlDataVal02.html

totally lost wrote:

is it possible to have one drop down list affect which drop down list comes
in on the next row? For example, my first drop down defines a type of
machine, so you would select which type of machine you need. then if you
select, say a model 400. the next drop down list would only display parts
applicable for the model 400.

--

Dave Peterson

how do I get one dropdown menu to trigger another one in excel
 

Check this:
http://www.contextures.com/xlDataVal02.html
Micky


"totally lost" wrote:

is it possible to have one drop down list affect which drop down list comes
in on the next row? For example, my first drop down defines a type of
machine, so you would select which type of machine you need. then if you
select, say a model 400. the next drop down list would only display parts
applicable for the model 400.