@ sweep: thanks for the link. I've frequented this section of Debra Dalgleish's site and though it deals with the dynamic dependent lists it uses a roundabout approach and extra named ranges to achieve that

@Marvin: yes, these are cascading drop downs, but with dynamic named ranges (not static ones)

@ Bob: The CHOOSE option is handy and I'll explore the possibilities of using that, although with many dynamic ranges it'd be cumbersome. Does seem like the best option under the circumstances.

Thanks all for responding