Forum Discussion
Data validation won't allow formulas
Hello, I am trying to create a drop down list that references a table, however the application is not allowing me to use a formula in the source selection. See below. Any ideas? Thanks, ...
Try using =$A8:$A9
If that source is defined as a legitimate Excel Table, that reference should expand as new rows get added. I just duplicated that resolution with a data validation of my own.
If that source is defined as a legitimate Excel Table, that reference should expand as new rows get added. I just duplicated that resolution with a data validation of my own.