I believe that I am successful with an interim solution to my original
problem.
This DropBox link, I think, will allow you to download my interim
solution, which comes with some caveats and compromises:
https://www.dropbox.com/s/05gk2h8zt7lbua2/Calc%20Help-updating%20Data_INTERIM%20SOLUTION.ods?dl=0
The caveats and compromises are presented in the referenced .ods file by
way of annotated comments on the content of cells as used in my solution.
I am very appreciative to AlanB for the time he has spent in an effort
to lead me toward the correct Calc sheet. Believe me, I have learned
from his thoughtfulness and patience to explain why he made specific
suggestions for changing my approach. This is how I am able to learn.
Thank you Alan! If it were not for your assistance, I would not have
gotten to this point.
In his 1/24/2020 posted reply, Alan mentioned a glitch involving cell
G36. I have not been able to duplicate the problem.
Alan's logic for the formula in cell J6:
* The formula in cell J6 for "Total Pins" column calculates total pins for
rows 6 through row the formula is in.
=IF(ISNUMBER(I6),DSUM($G$5:INDIRECT(CONCATENATE("$G",ROW())),1,$BB$5:$BB$6),"")
This formula should be copied to all week# rows in column J. It updates
correctly for each row it is in.
is far above my present skill level. Thus, I may return to it in the
future when I attempt to set up a calc sheet for a new WINTER SR LEAGUE
bowling season.
Yes, this all started with my goal of AL7 and AN7 being updated
automatically, without first changing the enclosed formula or being
modified by hand. My interim solution allows for auto-updating of AL7.
Cell AN7 is simply: AN7=(AL7/3).
Regards,
VinceB.
P.S. The PBA Oklahoma Open Bowing Tournament stepladder finals are
presently being televised on FS1 channel. I'm gone!
