I need a custom data validation drop down box - basically I have a table of name value pairs but I want filter the list in the drop down box such that I can only list names with a value less than that calculated in another cell.
i.e.
name value
pick1 10
pick2 20
pick3 14
pick4 13
maxpick = 15
then the list box should show pick1, pick3 and pick4
What would be the best approach to do this? I would like to do it with list validation but maybe I have to use a control and some vba?
Bookmarks