BryceDuncan2
New Member
I have a drop down with 11 possible options, but not all of them are available options at all times. For example, depending on other cells, there may be 3 or 5 options.
In this scenario, there are only 10 possible options, so I get the annoying empty spaces.
How can I set it to adjust with the amount of available options? I have the named range "Options1" = the number of options (10). I just can't set the list row to update to 10 dynamically.
In this scenario, there are only 10 possible options, so I get the annoying empty spaces.
How can I set it to adjust with the amount of available options? I have the named range "Options1" = the number of options (10). I just can't set the list row to update to 10 dynamically.