dependent dropdown size depends on selection

  • I've found multiple sources listing a myriad of ways to create a dependent dropdown list that either uses data validation and other options.


    Is it possible to vary the total number of dropdown lists based on what is needed?


    Say I have 3 items in a main list. The first and second have 3 levels of selections that could be selected from a dropdown list, but the third has a fourth.


    How can I tailor the sheet to show the correct number of lists? I.e. the first two would only show 3 dropdowns, the third would show 4?


    Or is it possible?


    TIA.


    *also, this is very new in the creating phase, although I can make a dummy sheet showing what I'm saying if it isn't clear...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!