How to make an input in one column determine dropdown list in anot
 

Is there any way I can make the info thats input in one column (selected by
dropdown list) determine which (one of several) dropdown list is used in
another column?

How to make an input in one column determine dropdown list in anot
 

Not quite sure of your question. Do you need to create drop down lists?

"gettin-older" wrote:

Is there any way I can make the info thats input in one column (selected by
dropdown list) determine which (one of several) dropdown list is used in
another column?

How to make an input in one column determine dropdown list in anot
 

great examples at:
xlDynamic.com
dave

How to make an input in one column determine dropdown list in
 

Ok.. I have a dropdown list (8 items) already created for column B. I would
like to know if there is a way for each of those 8 items in column B to
(individually) determine what can be selected for input in column C, again
by dropdown lists. Which dropdown list is shown for column C would depend on
what was selected for column B.

"sir Lancelot" wrote:

Not quite sure of your question. Do you need to create drop down lists?

"gettin-older" wrote:

Is there any way I can make the info thats input in one column (selected by
dropdown list) determine which (one of several) dropdown list is used in
another column?

How to make an input in one column determine dropdown list inanot
 

As answered in microsoft.public.excel.misc:

If these are data validation dropdown lists, there are instructions here
for dependent lists:

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

gettin-older wrote:
Is there any way I can make the info thats input in one column (selected by
dropdown list) determine which (one of several) dropdown list is used in
another column?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

How to make an input in one column determine dropdown list in
 

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

--
Regards,

Peo Sjoblom

(No private emails please)


"gettin-older" wrote in message
...
Ok.. I have a dropdown list (8 items) already created for column B. I
would
like to know if there is a way for each of those 8 items in column B to
(individually) determine what can be selected for input in column C,
again
by dropdown lists. Which dropdown list is shown for column C would depend
on
what was selected for column B.

"sir Lancelot" wrote:

Not quite sure of your question. Do you need to create drop down lists?

"gettin-older" wrote:

Is there any way I can make the info thats input in one column
(selected by
dropdown list) determine which (one of several) dropdown list is used
in
another column?

How to make an input in one column determine dropdown list in
 

Thank you very much!

"Debra Dalgleish" wrote:

As answered in microsoft.public.excel.misc:

If these are data validation dropdown lists, there are instructions here
for dependent lists:

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

gettin-older wrote:
Is there any way I can make the info thats input in one column (selected by
dropdown list) determine which (one of several) dropdown list is used in
another column?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html