I am trying to create a sheet with doubled drop-down lists?

G

Guest

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

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down Lists 1
Create a Drop down List on a Form 2
EXCEL DROP DOWN 2
Print Macro with two drop-down lists 4
show and hide a drop down list 1
Drop Down Lists 2
Pick from drop-down list gives empty or erroneous result 6
Drop Down Menus 2

Top