Lists

P

PaulW

I know this is probably a really simple one, but i just cant figure it out!

I have a form with a bunch of drop down lists. What i want is based on one
drop down list only show a select number of options in a second drop down
list, then based on that second one give again a limited number of answers on
that one.

Please help.

many thanks
 
M

Max

PaulW said:
I have a form with a bunch of drop down lists. What i want is based on one
drop down list only show a select number of options in a second drop down
list, then based on that second one give again a limited number of answers on
that one.
Click to expand...

Try Debra's page at:
http://www.contextures.com/xlDataVal13.html
Data Validation -- Dependent Dropdowns from a Sorted List

Another good source is Bob Phillips':
http://www.xldynamic.com/source/xld.Dropdowns.html
Dynamic Dependent Dropdowns
 
Top