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