Thread: Data Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ArthurJ
 
Posts: n/a
Default Data Validation

I am using data validation techniques to create a drop down list that depends
upon the user's choice on an earlier drop down list. This is called
"Dependent Data Validation" in the wonderful Contextures website.

I want to use dynamic range definitions so that the lists can be altered
easily. But my dependent data validation cell does not seem to like this.

Does anyone know if dynamic range definitions create a special sort of
difficulty when used in this manner?

Art