Cascading data validation?

[Robert H]

I’m using data validation to list cell input choices in a weekly task
report. To clean things up and further limit choices I want to limit
the choices in column C based the choices in column B etc.

For example:
B( Systems)
1
2
3
4

C(Task)
A
B
C
D
E

System 1 only accepts Task A
Systems 2 and 3 accept Task B,C and D
System 4 accepts all tasks.

There are several layers of subtasks.

I have the lists set up in named ranges on a separate sheet.

These reports will be generated on PCs at a military installation that
has dense security restrictions so don’t even want to attempt to use
VBA code.

 

[Don Guillett]

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
I’m using data validation to list cell input choices in a weekly task
report. To clean things up and further limit choices I want to limit
the choices in column C based the choices in column B etc.

For example:
B( Systems)
1
2
3
4

C(Task)
A
B
C
D
E

System 1 only accepts Task A
Systems 2 and 3 accept Task B,C and D
System 4 accepts all tasks.

There are several layers of subtasks.

I have the lists set up in named ranges on a separate sheet.

These reports will be generated on PCs at a military installation that
has dense security restrictions so don’t even want to attempt to use
VBA code.

 

[Roger Govier]

Hi Robert

Take a look at this method I posted at Debra Dalgleish's site
http://www.contextures.com/xlDataVal15.html

 

[Robert H]

I'm experimenting with the Data Validation techniques at
Contextures.com Thanks Don and Roger!
Robert

 

[Don Guillett]

Glad to help