dependent drop down boxes and dynamic ranges

It needs work-arounds. What is the formula that you are using and some
sample data?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"philcud" <philcuddy@gmail.com> wrote in message
news:1125569808.582148.100790@g47g2000cwa.googlegroups.com...
> hi all,
> have created a drop down box that is dependent on another cell, using
> the indirect function to get the name from another cell.
> heowever, when i amend the names to dynamic ranges, this stops the drop
> down boxes getting their list - anyone got dependent drop down boxes to
> workj with dynamic ranges?
>

You can use the technique shown here for using dynamic lists with
dependent dropdowns:

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

philcud wrote:
> hi all,
> have created a drop down box that is dependent on another cell, using
> the indirect function to get the name from another cell.
> heowever, when i amend the names to dynamic ranges, this stops the drop
> down boxes getting their list - anyone got dependent drop down boxes to
> workj with dynamic ranges?
>


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

It needs work-arounds. What is the formula that you are using and some
sample data?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"philcud" <philcuddy@gmail.com> wrote in message
news:1125569808.582148.100790@g47g2000cwa.googlegroups.com...
> hi all,
> have created a drop down box that is dependent on another cell, using
> the indirect function to get the name from another cell.
> heowever, when i amend the names to dynamic ranges, this stops the drop
> down boxes getting their list - anyone got dependent drop down boxes to
> workj with dynamic ranges?
>

You can use the technique shown here for using dynamic lists with
dependent dropdowns:

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

philcud wrote:
> hi all,
> have created a drop down box that is dependent on another cell, using
> the indirect function to get the name from another cell.
> heowever, when i amend the names to dynamic ranges, this stops the drop
> down boxes getting their list - anyone got dependent drop down boxes to
> workj with dynamic ranges?
>


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

hi all,
have created a drop down box that is dependent on another cell, using
the indirect function to get the name from another cell.
heowever, when i amend the names to dynamic ranges, this stops the drop
down boxes getting their list - anyone got dependent drop down boxes to
workj with dynamic ranges?

It needs work-arounds. What is the formula that you are using and some
sample data?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"philcud" <philcuddy@gmail.com> wrote in message
news:1125569808.582148.100790@g47g2000cwa.googlegroups.com...
> hi all,
> have created a drop down box that is dependent on another cell, using
> the indirect function to get the name from another cell.
> heowever, when i amend the names to dynamic ranges, this stops the drop
> down boxes getting their list - anyone got dependent drop down boxes to
> workj with dynamic ranges?
>

You can use the technique shown here for using dynamic lists with
dependent dropdowns:

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

philcud wrote:
> hi all,
> have created a drop down box that is dependent on another cell, using
> the indirect function to get the name from another cell.
> heowever, when i amend the names to dynamic ranges, this stops the drop
> down boxes getting their list - anyone got dependent drop down boxes to
> workj with dynamic ranges?
>


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