Changing the worksheet name in multiple formulas (possibly using INDIRECT)
Good afternoon everybody and many thanks in advance for any possible assistance. I have done multiple searches for a solution without success, although INDIRECT in the correct syntax could be a possibility
I only really know basic Excel so please do not laugh at this question
A friend and me play a few 'wordle type games' every day and I collate all the score onto a weekly worksheet. I currently have to change the name of the latest worksheet onto 8 formulas on the running total worksheet every week to keep the scores current.
How would I be able to just type the current playing week into a cell such as the one shown with red writing and get it to automatically go into the formula area marked?
Any help would be greatly appreciated and sorry for the stupid question, I have tried and tried many possible solutions and it always gives me an error.
I have attached a snapshot of the Running Totals worksheet for reference.
Many thanks
|