Data validation list decreases as the user chooses from the list/s

E

Emdyey

I am trying to create a validation list in Excel 2003 with two or more
sub-lists. For example, the first validatation list contains 4 options. Each
option has sub-options. And each sub-option has sub-options also. I would
like to accomplish a list that when the user select 1 option from the main
list it will only show its sub-options. And as you select the sub-option it
will show the sub-sub-options.
Find below the illustration

List:
Actions => 4 sublists => each sublist => 10 sublists
Conditions => 4 sublists =>each sublist => 10 sublists
Personal Factors => 5 sublists =>each sublist => 10 sublists
Job Factors => 9 sublists =>each sublist => 10 sublists

Example:

Actions
l---> Following procedures
l----> Individual, Group, Supervision, Improper loading, etc.

l---> Use of Tools or Equipment
l---> Use of Tools, Use of Equipment, Use of Defective
Tools, etc.

And so on, so forth.

Hope you can help me with my problem.

Thanks in advance.
 

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

Top