Forum Discussion
Autopopulate a drop down from another drop down
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.
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.