First, create the first, second and third drop down list data as below screenshot shown: The second method is an event procedure that makes sure there are drop-down lists in column A if there are adjacent values in column B and C. here highly recommended the multi select drop down list feature of kutools for excel for you. Excel Dependent Drop Down Lists Using Tables.
Dependent drop down list vba There should be two dropdown lists on another sheet, one of which depends on the other's selected value.
