Forum Discussion
Excel ranges - can I create dynamic absolute references
So...I'm hopeful I can explain my question adequately and find some solutions to the challenges I'm having with my latest spreadsheet project. In a nutshell, I have a handful of spreadsheets that I'm...
Create a name in name managers in Formula tab on Ribbon
=INDIRECT("$D$5:$D$200")
all formula use that name.
However, as you can see, its size is a fixed because in the indirect formula, the range string is fixed. You may have to change it to dynamic increasing its size to fit the future needs.