If I have a named range, say from A1 - A200 called Transactions.
But then later I add more data, say to A250 is there an option to where the Named Range is automatically updated and I do not have to edit the named range to add the extra cells?
Named Ranges - Dynamically change?
-
- Administrator
- Posts: 12608
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
-
- Administrator
- Posts: 78493
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Named Ranges - Dynamically change?
StuartR's suggestion is excellent.
If you prefer to use a named range, you could define Transactions as follows:
=OFFSET($A$1, 0, 0, COUNTA($A:$A), 1)
If you prefer to use a named range, you could define Transactions as follows:
=OFFSET($A$1, 0, 0, COUNTA($A:$A), 1)
Best wishes,
Hans
Hans