Drop down lists

[Connor Demp]

Is there a way to make lists dependent on just one list without having to use the indirect function and making categories? If so, is it possible to make those lists reset (go to a blank cell waiting to be fill in from the list)?

 

[AlanSidman]

Here is a link to a VBA solution which is alternative to the Indirect solution

https://www.thesmallman.com/cascading-drop-down-lists