This is a Drop Box link to my (whole nine yards)
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.