I am trying to create an excel 2003 sheet with doubled drop-down lists. I
inherited a sheet that does this, so I know it is possible, but every time I
try to figure out how, it just says "this section contains more then one kind
of data-validation" and I cannot get beyond the error message. The lists seem
to function so that the drop down on the left allows the user to pick a
category, and once a selection is chosen from that list the drop down on the
right is activated, allowing the user to then select specifics, like a normal
drop-down list. I can send a copy of this original sheet if someone needs an
example. - I am just wondering how to create one of my own.

See Debra Dalgleish's website for instructions on using Dependent Lists:
http://www.contextures.com/xlDataVal02.html

Does that help?

Post back with more questions.
***********
Regards,
Ron

XL2002, WinXP


"Luna" wrote:

I am trying to create an excel 2003 sheet with doubled drop-down lists. I
inherited a sheet that does this, so I know it is possible, but every time I
try to figure out how, it just says "this section contains more then one kind
of data-validation" and I cannot get beyond the error message. The lists seem
to function so that the drop down on the left allows the user to pick a
category, and once a selection is chosen from that list the drop down on the
right is activated, allowing the user to then select specifics, like a normal
drop-down list. I can send a copy of this original sheet if someone needs an
example. - I am just wondering how to create one of my own.

I just completed trying this. It 80% answers my question...but it leads to a
problem I hadn't previously anticipated.
My question is this what would one do if we needed it to populate other
columns from the subsidiary list. for example (using the examples in the
aforementioned page) how would one say have it populate not just Apples in
the fruits category, but then have it populate a spot where say, it would say
apples and the price in the next column...plus maybe a place where it would
then allow a user to add a formula to calculate cost if one wanted say 5
apples. but still using this dependant lists format.

illustrated here as best I can:
Produce Subsist price qty. total
Fruits Apples .49 (user fill) (formula)

I hope that makes sense...and thank you so much for the link.


"Ron Coderre" wrote:

See Debra Dalgleish's website for instructions on using Dependent Lists:
http://www.contextures.com/xlDataVal02.html

Once again, Debra Dalgleish has the answer for you. See her Order Form
example:

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

Does that help?

***********
Regards,
Ron

XL2002, WinXP


"Luna" wrote:

I just completed trying this. It 80% answers my question...but it leads to a
problem I hadn't previously anticipated.
My question is this what would one do if we needed it to populate other
columns from the subsidiary list. for example (using the examples in the
aforementioned page) how would one say have it populate not just Apples in
the fruits category, but then have it populate a spot where say, it would say
apples and the price in the next column...plus maybe a place where it would
then allow a user to add a formula to calculate cost if one wanted say 5
apples. but still using this dependant lists format.

illustrated here as best I can:
Produce Subsist price qty. total
Fruits Apples .49 (user fill) (formula)

I hope that makes sense...and thank you so much for the link.


"Ron Coderre" wrote:

See Debra Dalgleish's website for instructions on using Dependent Lists:
http://www.contextures.com/xlDataVal02.html

Thank you, thank you, thank you! It took a little tweeking between these two
pages. But I am now confiident that I will be able to complet this project,
and Its easyer then I ever thought it would be. add in a little conditional
formatting, and this thing is working out great. Thank you so much for your
help.

"Ron Coderre" wrote:

Once again, Debra Dalgleish has the answer for you. See her Order Form
example:

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

Does that help?

***********
Regards,
Ron

XL2002, WinXP