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?

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?

great examples at:
xlDynamic.com
dave

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?

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

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?

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