Forum Discussion
Solved
Sum cells across multiple changing sheets
Can someone tell me how I can create a summary page across multiple sheets that will have changing totals? I know how to set the summary with set numbers but as I update the totals on the sheets, is ...
Candace1 If the location of a cell moves due to inserting or deleting rows or columns excel will automatically update the referring cells. If the cells on those other sheets aren't all in the same location you can manually select each cell on each sheet. But I'm guessing you have a problem beyond that so what about finding a fixed cell on each sheet that won't change and have it reflect/reference the cell of interest on that sheet?
Hello,
Just a suggestion. You can combine all the data from the different sheets into a single sheet. Then, you can format the data as Excel Tables and create a PivotTable Report.
When new data is added to the source data, you can easily refresh your PivotTable
Just a suggestion. You can combine all the data from the different sheets into a single sheet. Then, you can format the data as Excel Tables and create a PivotTable Report.
When new data is added to the source data, you can easily refresh your PivotTable