Combobox if range of dropdown is dependent of inout in other cell

[Holmes1988]

Hi

I'm trying the get a dropdown to autofill and read that a combobox would be the best solution.

What i'm struggling with is that my dropdown range is dependent of an input in another cell - it's dynamic, based on which value i chose.

When i insert a combobox the values i can choose in it is only the formula in which is describe which area the validation list should get it's data from. That's not what i want.

Does anyone know a solution to this?

Martin