I have created multiple drop down lists in Excel for user to select the value by using the data validation function
However I have 5 dropdown lists and each drop down list depends on the value selected in the Dropdown list above.
I have more than 3000 values, it is hard for me to define Named Range.
It would be great if I can put the whole data table in Excel and then in the drop down list use formula as source.
It would be great if any experts can help me on this.