Hello from sunny Australia. I have two Data Validation dropdowns where the 2nd dropdown depends on the contents of the first dropdown. To explain it better, I have attached a jpg explaining the interaction. Any help greatly appreciated. Peter.
Hello from sunny Australia. I have two Data Validation dropdowns where the 2nd dropdown depends on the contents of the first dropdown. To explain it better, I have attached a jpg explaining the interaction. Any help greatly appreciated. Peter.
Do you have the dependent data as separate lists? Post your workbook, it should be a doddle then.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber