dependent lists

Hi All, I want to create many dependent drop list (more than 100) that auto refresh when the source list changes. I am able to auto update the list using data validation and by changing the source list using named ranges but the selected item doesn't change unless I re-select the data...

Thanks for your help. I have a number of Suppliers and I have listed the products they supply under the Customer name. I want to be able to choose a Supplier and have the output generate the list of products for the Supplier. I would also like to get the output to display 2 other features: a)...

I'm trying to build an interface that will allow others to select a specific product that will then give a subset of that specific lot. For instance my first list would be something like: Product Type Inventory Apple Red 2 Pickle Sweet 1 Orange...