Related Posts
GSP San Fran or Leo Chicago?
Seattle vs San Diego?
More Posts
Any travel recommendations in December?
Additional Posts in Excel Genius
Would anyone be willing to teach me vlookup?
Everyone: Excel is a smart app
Excel:

PowerQuery > PowerBI .. thoughts ?
Why don't recent grads know how to use excel?
New to Fishbowl?
unlock all discussions on Fishbowl.









Subject Expert
Without VBA (aka simple):
- Possible but have limitations. The idea would be to use a spill function (e.g.: =FILTER()) and use data validation on the range. The limitations would be:
i) You have to have automatic calculations enabled otherwise the output won't change
ii) You have no way to control if =FILTER() output will be 5, 10 or 50000 directly (you can create constrains in the function but not the case)
Remember to check the "ignore blank option" if blank is not an option.
With VBA (aka complicated):
- Possible, but troublesome to build. Constrained by edge cases
Subject Expert
Like this
You can use a conditional named range to return the values to your drop down list. Worth a google :)
VBA is the way to go and isn’t difficult at all with the newest versions of excel. Just make sure you have your developer ribbon enabled in options —> go to developer tab—> click design mode—> insert—> list box
And you have yourself a drop down menu
I would check out
Www.excel-easy.com/VBA/activex-controls.html