Dynamic Data Validation Lists

[Daniel Brown]

Hello

I have three lists associated to three products. Product A has List A, Product B has List B... When I select Product B (say) in a Data Validation List, I want the contents of my next Data Validation List to contain the data contained in List B. If I change the product in the first list to Product A, I want the second list to change to List A. Easy in javascript.

Any tips please.

I am using Excel 2010.

Regards

[alansidman]

Here is a link on Dependent Data Validation that should help you over this hurdle.

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