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.
