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).
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.
Please download the sample workbook from my first reply.
Right-click the sheet tab of the first sheet and select View Code from the context menu to see the VBA code used.
I think coding might be a little advanced for me! lol
If you wish, you could attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar.