Forum Discussion
christine1314
Dec 14, 2023Copper Contributor
How to create a cascading dynamic dropdown list
I am trying to create a dynamic dropdown list (which I can do), but then cascade/apply it to multiple rows (can't do). I have a source table with 3 columns of data column C- business unit, co...
christine1314
Dec 17, 2023Copper Contributor
djclements Thank you. We've been able to make this work by putting it in the data validation for each cell, however, as we could be entering up to 100 rows of data, we aren't keen to have to replicate this data validation formula 200 times. Any way it can be referenced once in H4 and I4 to avoid having to enter the formula 200 times? That way the data validation can just reference the list that the formula creates.
peiyezhu
Dec 18, 2023Bronze Contributor