B
bouncebackability
the example...
i have a sheet called 'totals' created from entering data on sheets
'week 1 and week 2'.
at the end of the season i want to start a second season. so it clears
all the data on the week 1, week 2 and standings sheet (but has
recorded the data from the totals sheet on a sheet called 'Season 1')
i then do the second season in the same way. and have a sheet called
'season 2'
but what i want to do is have a cummulative total from both season 1
and season 2 on a 'records' sheet without having to update the formula
myself. but as the season 2 sheet isnt there to begin and assuming
there will be many more seasons to come, has anyone got any
suggestions???
thanks in advance
i have a sheet called 'totals' created from entering data on sheets
'week 1 and week 2'.
at the end of the season i want to start a second season. so it clears
all the data on the week 1, week 2 and standings sheet (but has
recorded the data from the totals sheet on a sheet called 'Season 1')
i then do the second season in the same way. and have a sheet called
'season 2'
but what i want to do is have a cummulative total from both season 1
and season 2 on a 'records' sheet without having to update the formula
myself. but as the season 2 sheet isnt there to begin and assuming
there will be many more seasons to come, has anyone got any
suggestions???
thanks in advance