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


"ArthurJ" wrote:

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

There's information on the dependent data validation page that describes
how to use dynamic lists. Is that the technique you used:

http://www.contextures.com/xlDataVal02.html#Dynamic


ArthurJ wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

"Debra Dalgleish" wrote:

There's information on the dependent data validation page that describes
how to use dynamic lists. Is that the technique you used:

http://www.contextures.com/xlDataVal02.html#Dynamic


ArthurJ wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

It looks like you created the dynamic range correctly. However, you
can't use these dynamic ranges in the dependent data validation formula.
The link that I included:

http://www.contextures.com/xlDataVal02.html#Dynamic

describes a workaround for the problem.


ArthurJ wrote:
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

"Debra Dalgleish" wrote:


There's information on the dependent data validation page that describes
how to use dynamic lists. Is that the technique you used:

http://www.contextures.com/xlDataVal02.html#Dynamic


ArthurJ wrote:

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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html