Is there a way to automatically transfer running-total formulas written from
one spreadsheet to another, that automatically updates the worksheet formulas
from the previous sheet to the next? For example, if sheet 2 has reference
formulas (running totals) that carry from sheet 1, can I start sheet 3 to
automatically inherit the same formulas but automatically reference to sheet
2, that referenced a running total from sheet 1, without having to go through
each cell and rewrite the formula to correspond to the current page (sheet 3)
and previous page (sheet 2)? I hope I've explained this clearly. I am
working on spreadsheets that have numerous, running-total formulas and it
would be a pain to have to go through and rewrite each one.