Forum Discussion

Branden_Reynolds's avatar
Branden_Reynolds
Copper Contributor
Feb 09, 2022

Accounting for a budget

How do you keep a running balance to start from one spreadsheet, labelled February, to populate on the next spreadsheet, labelled March, and keep this balance running for the next spreadsheets? The balance in all of the months will have a an add and subtract formula in the cell

Formulas and Functions

1 Reply

  • jitinm's avatar
    jitinm
    Iron Contributor
    Feb 10, 2022
    You must have allocated a particular cell in the Feb month (for example) budget sheet which would be same for all the next and previous budgets. Similarly would be the Opening Balance cell for all. You can directly link the closing of the previous with the opening of the next. Since cells are same for all sheets. the Formula will directly picks the amount.