Home |
Search |
Today's Posts |
#1
|
|||
|
|||
adding up sheets that arent there yet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why isn't arent all my case notes transfering in a pivot report? | Excel Discussion (Misc queries) | |||
spread sheets - adding | Excel Worksheet Functions | |||
Why arent my blank cells moved to the end when I do a sort? | New Users to Excel | |||
Adding Sheets | Excel Discussion (Misc queries) | |||
Macro for adding more sheets | Excel Discussion (Misc queries) |