Prev: Prevent cut & paste in a protected worksheet.
Next: What is the syntax for control+UpArrow in Macro?
From: totally lost on 5 Apr 2010 15:56
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.
From: Paul on 5 Apr 2010 15:57

You should look into "dependent data validation lists", as outlined
here:

'Excel Data Validation -- Dependent Lists'
(http://www.contextures.com/xlDataval02.html)




t
o
t
a
l
l
y

l
o
s
t
;
6
9
0
8
4
6

W
r
o
t
e
:


>
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.


--
Paul

- Paul
------------------------------------------------------------------------
Paul's Profile: 1697
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=193117

http://www.thecodecage.com/forumz

From: Dave Peterson on 5 Apr 2010 16:01
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
From: מיכאל (מיקי) אבידן on 5 Apr 2010 16:11
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.
 | 
Pages: 1
Prev: Prevent cut & paste in a protected worksheet.
Next: What is the syntax for control+UpArrow in Macro?