Data Validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try giving us a few more details about how you are creating your dynamic
range names and your data validation settings. Maybe then we'll have enough
information to chance a suggestion.

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Debra,

Yes, I believe I have followed the dynamic lists instructions properly from
your website. I have used them before with good success.

Example entered into the "Refers to:" box of Define Name dialog:

=offset(Lists!$B$4,0,0,COUNTA(Lists!$B:$B),1)

I actually used range names rather than the cells in the formula. I wonder
if that had something to do with the problem.

After I could not resolve the error I went back to just traditional name
ranges (non-dynamic). The dependent data validation is working fine now. (I
do have another issue that I am going to post in the Programming thread).

Thanks for your help.

Art
 
Back
Top