Excel Dynamic Dependent Dropdown List with Custom Data Validation
Let us suppose we have Months in the Colum A (A1:A13).Now, by using the Custom Drop Down Technique , we can display the Month Names in the drop down list(Dependent list) under each Quarter that you selected (Q1_,Q2_,Q3_..) from the Independent Drop Down List.
This is a Most Useful Technique , in real time Data Analysis scenario.
First Define Range Names for the Data Items(Months) as below :
Range A2:A4(Jan,Feb,Mar) as Q1_ , A5:A7(Apr,May,Jun) as Q2_……….Etc.
Next right to the Quarter Dropdown Cell (E2) , where you want to display the Months List , define the following Custom Data Validation/Custom Drop Down as shown below :
Now you can see the Months list ( Dependent List ) for each Quarter (Independent List) that you selected as shown below :