Originally Posted by
NBVC
Create a named range for the dynamic range.
So If, for example on your attached example you have the Vehicle combobox and say you have different combinations of fuel types based on vehicle chosen.. so now you would have separate named ranges for Motorcyle, Car, Bus, etc. listing the fuel types....
Then you can use the B2 result (which displays the choice of vehicle you made in a cell)... and name a range, eg. DynamicRange and use formula =Indirect($B$2)
Now, the Fuel combobox, input range would be DynamicRange
I did a quick sample on the attached...
Bookmarks