I looked around but tried some solutions and could not make it work.
I have a several data validation lists through Row 20. Usually, I will drag Row 20 down to whatever row I need, and the validation list follow.
Some of the validation lists values have numbers in them "24" and once dragged it becomes "25, 26, 27 etc".
I have a several data validation lists through Row 20. Usually, I will drag Row 20 down to whatever row I need, and the validation list follow.
Some of the validation lists values have numbers in them "24" and once dragged it becomes "25, 26, 27 etc".