Please help me with the following dropdown list problem.
I want to start the list (range) in Cell W102 through W120.
As the list grows the dropdown must dynamically update as to avoid blank at the end, but should not go further then W120
I have tried this formula without any success.: $W$1:INDEX($W:$W,COUNTA($W:$W),1)
I then changed it to
$W$102:INDEX($W102:$W120,COUNTA($W102:$W120),1) and, alas also unsuccessful
Could you possibly help?
Thanks
Sias