theterminator
Wise Old Owl
I have an excel which I update daily by creating a sheet for every day and then having a cumulative sheet at the end which adds up all the values in the multiple sheets.
In the above sheet, I have data for 08.06.2020 & 09.06.2020 and a cumulative sheet that sums up the data in the sheets to the left. I applied the sum function in the Cumulative sheet today and it has cumulative data. The structure of all the sheets are the same so the SUM function worked. But is there a way to automatically add new data of a newly added sheet to the left of Cumulative sheet. For example, I want to feed data of 10.06.2020 and add it to the left of Cumulative but I want that the cumulative sheet automatically updates itself. I've tried by adding a new sheet but the SUM formula won't extend to the new sheet.
In the above sheet, I have data for 08.06.2020 & 09.06.2020 and a cumulative sheet that sums up the data in the sheets to the left. I applied the sum function in the Cumulative sheet today and it has cumulative data. The structure of all the sheets are the same so the SUM function worked. But is there a way to automatically add new data of a newly added sheet to the left of Cumulative sheet. For example, I want to feed data of 10.06.2020 and add it to the left of Cumulative but I want that the cumulative sheet automatically updates itself. I've tried by adding a new sheet but the SUM formula won't extend to the new sheet.