Forum Discussion
Solved
Set the value of a cell within a range and change it automatically
Hello to everyone! I have seen that you can set a data validation for a cell, so if you want the value of that cell to be within a range, an error message would appear. What I want is to set a v...
Maybe something like this dynamic dropdown will work. It will list out all of the numbers between 1 and the Maximum that you specify. See attached .xlsx file for an example.
It uses this data validation formula: =OFFSET($E$1,0,0,B1,1)
I believe what you're referring to is called dependent drop downs. Debra Dalgleish has a great article on how you can create this type of validation. Please see the below link which has a step by step tutorial, video and example file:
https://www.contextures.com/xlDataVal13.html#dependent