Variable Data Validation
Posted by Zif on January 22, 2001 4:03 AM
I have a column (Division) which is populated by users selecting a Data Validation entry (or by typing in a valid entry).
In the next column (Department), I would like the data Validation to show only those entries which are valid for the Division entered in the previous column.
Division 1 contains Dept1, Dept2, Dept3 and Dept99
Division 2 contains Dept6, Dept7, Dept8, Dept9 and Dept99
If the user specifies Division 1, Data Validation should only allow Dept1, Dept2, Dept3, Dept99.
If the user specifies Division 2, Data Validation should only allow Dept6, Dept7, Dept8, Dept9, Dept99
I'm not sure if this is possible using Data Validation, but I'd like to use this facility so that the users can use the drop down box feature.
Hope someone can help.