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 Since the number of rows is increasing over the year, I would like to name that range and use it as a replacement in the formulae. Then, whenever I find that I need to insert additional rows, I think there is a simpler method to edit/modify the named range of cells to end at a $L### cell, as needed. Does this make any sense? Is it possible to do, rather than using Search and replace for each appearance of $L450 with a new ending range point cell, $L###? I hope that I described the problem and my goal clearly enough. Regards, VinceB.
