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).
See the attached version. It uses a combination of Data Validation and VBA (in the worksheet module).
This is exactly what I'm trying to do but I'm having difficulty with the formula. I'm not sure how to use IF, VLOOKUP, etc.