Hi Everyone,
I would like to know if it is possible to create dependent dropdown selections. I have attached a spreadsheet that has two nested dropdowns. What is displayed in the second dropdown is dependent on what was selected in the first dropdown. What I would like to do is carry this dependency several dropdowns further. Basically similar to the folder structure in Windows. Once you select a folder you can only choose the folders within that folder. It needs to go a 4 levels deep. The goal is too choose the product, model, voltage, phase and finally the circuit breaker based on all the previous selections.
If anyone can tell me how to create the nested, dependent dropdowns it will be greatly appreciated. This forum got some amazing Excel talent so I hope it can be done.
Thanks in advance to anyone that helps.
Bookmarks