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

"PaulW" wrote:
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.

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

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---