Complex Dependent Drop Down List

[DJPaton]

Hi

I have been learning about and using dependant drop down lists (thanks Jerry Beaucaire!) and now I am trying to complete a much more complex dependant drop down list and I am stuck.

I have 49 product types e.g. Accountants Professional Indemnity and for each product type there will a different set of Section, Risk and Coverage types. So for example when the product type 'Accountants Professional Indemnity' is selected from a drop down list the 'Section', 'Risk' and 'Coverage' drop down lists will be limited to the ones specific to the product type selected. I have already created all the specific lists for all the products but I am faltering after that.

Any help will he enormously appreciated.

Cheers

Derek

 

[Toonies]

hi try

http://www.contextures.com/xldataval02.html

http://www.contextures.com/xldataval13.html

should put you on the right track

Toonies

 

[DJPaton]

Thanks Toonies, I have been working with those links but it just doesn't seem to go as far as I need it to. For example, how do I assign a named range three times for each product type?