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.
Regards, VinceB. 

Reply via email to