Hi guys,

I wonder, is there a way how to make dependant dropdown list without the need for SOOOO many named ranges when there is like 24&150&7500 things to choose from? Itīs meant that 24 instances in 1st dropdown, over 150 in second and i think u guessed....7500 in the 3rd dropdown list....it would take quite some time to spread all those occurances to relevant lists as most manuals suggest on how to do the dependant dropdown list. At the moment i have 3 columns with all the data and i need to make dropdown lists that would be able to work with just those 3 columns (i know how to do that through VBA) but i want to avoid the "onchange" method cause it will slow my file drasticaly and make the file almost unusable.

So any suggestions how to implement condition function so the array gets limited by it? Or any other way how to achieve it without using "onchange" and spreading all into so many ranges?