Forum Discussion
Solved
Autopopulate a drop down from another drop down
How do I set up to autofill several cells (containing drop downs) depending on the value of another drop down? For example, If x is selected from the dropdown in column A, then I want Columns B-...
See the attached version. It uses a combination of Data Validation and VBA (in the worksheet module).
You may google for "excel dependant drop-down list", lot of materials with samples. First I received Creating a Dependent Drop Down List in Excel [Step-by-Step Tutorial] (trumpexcel.com)