I've got a bit of an oddball one that's doing my head in. I feel its more complicated than I'm anticipating
I need two drop-down lists the second of which is dependent on the selection in the first.
- For argument's sake, Column A has a dropdown with 9 options
- If any of the green cells are selected, the second dropdown would give the green options in Column B 'Yes' or 'No'
- If any of the yellow cells are selected, there is no option and only 'Maybe' would show.
Dropdowns.PNG
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
In theory I could do that but its terribly clunky, not to mention how do you manage List titles when spaces are involved?
See if you can adapt this to your needs, it is a 3-level DD, but you can just use the 1st 2. It is based on using named ranged and INDIRECT()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks