I have a formula in my cells that refers to a separate sheet with some data in a single column, something like
A1:A500
However, new values are being added regularly so 500 becomes 501, 502, etc. I don't want to hardcode the last cell index, nor put there A2000 as a means to account for growth as that creates other problems.
Is it possible to reference the last row dynamically, something like:
A1:LAST(A)