Data Validation

[mrchoppychops]

Hi All

Please see the attached example. I have created a dependant data validation. The list available in B2 is dependent on the item chosen in Cell A2.

What I would like to know is how do I expand this validation down columns A and B. I don't want to have to add the validation in each cell individually!

Thanks

[Richard Schollar]

Hi

Copy>PasteSpecial>Validation.

Richard

[mrchoppychops]

Hi

Copy>PasteSpecial>Validation.

Richard

Hi this works, thank you.

[MickG]

Hi, I think if you select you Validation cells along with your extended range, then click validation, you get a msgbox asking if you want to extend the Data Validation Range.
Regards Mick

[mrchoppychops]

Hi, I think if you select you Validation cells along with your extended range, then click validation, you get a msgbox asking if you want to extend the Data Validation Range.
Regards Mick

indeed you do.

thanks for this tip.