On 10/16/2016 10:41 PM, Brian Barker wrote:
If you insert rows or columns, formulae containing ranges spanning
those insertions are automatically updated to expand the range. This
is true whether the range appears explicitly or as a name. In other
words, names are also updated appropriately.
At 18:23 16/10/2016 +, Vince Bonly wrote:
The formula that appears in C459 contains the text string: $D$343:$L450 .
That's not really a text string in this context but a cell range.
Since the number of rows is increasing over the year, I would like
to name that range and use it as a
This is a Drop Box link to my (whole nine yards)
spreadsheet:https://www.dropbox.com/s/0l47bmgpwlsx4bo/2016%20My%20Bowling%20Score%20Data.ods?dl=0
I draw your attention to the '2016 Scores sheet, Rows C459 thru C479. The
formula that appears in C459 contains the text string:$D$343:$L450