Linking Validation Lists?
Can you link drop down lists?
Example:
DropDown#1 has (A,B & C)
DropDown#2 has (1,2,3,4,5,6,7,8 & 9)
If Drop Down#1=A, Drop Down #2 = (1,2 & 3)
If Drop Down#1=B, Drop Down #2 = (4,5 & 6)
If Drop Down#1=C, Drop Down #2 = (7,8 &9)
Is this feasible?
Thanks,
Dan
|