Learn how to create a dynamic drop down list in Excel.
Here are the steps.
A) Create List Data Table
1) Select the list data cells.
2) Ctrl + T
3) Check on "My table has headers"
4) OK
B) Create Data Validation List
1) Select a cell.
2) Data -- Data Validation
3) Allow set to List
4) Source set to =$C$2#
C) Expanding Data Validation List
1) Select last item in the Data List
2) Tabs
3) Add list item. eg "Glue"
4) Enter
dynamic drop down list excel from another sheet,excel dynamic drop down list based on criteria,how to create drop down list in excel with multiple selections,how to create drop down list but show different values in excel,excel drop down list formula,excel dynamic dependent drop down list,filter with dynamic drop down list,
