Accounting for a budget

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3146432%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EAccounting%20for%20a%20budget%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3146432%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHow%20do%20you%20keep%20a%20running%20balance%20to%20start%20from%20one%20spreadsheet%2C%20labelled%20February%2C%20to%20populate%20on%20the%20next%20spreadsheet%2C%20labelled%20March%2C%20and%20keep%20this%20balance%20running%20for%20the%20next%20spreadsheets%3F%20The%20balance%20in%20all%20of%20the%20months%20will%20have%20a%20an%20add%20and%20subtract%20formula%20in%20the%20cell%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3146432%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

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

1 Reply
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.