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