Forum Discussion
Sum cells across multiple changing sheets
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?
mtarlerthanks for the suggestions. The 3rd option may work for me. To explain it a little more thoroughly, this spreadsheet has different companies on the sheets and will have updated totals as those companies purchase more items. I want updated totals on the summary but the specific cells with the totals will change as I add more line items.
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?