Cascading data validation?

  • Thread starter Thread starter Robert H
  • Start date Start date
R

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.
 
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.
 
I'm experimenting with the Data Validation techniques at
Contextures.com Thanks Don and Roger!
Robert
 
Back
Top