I'm trying to figure to if it's possible to do the following: I have an excel doc with monthly spreadsheets and I would like a number to be copied over always from the previous spreadsheet and add from another cell in the current spreadsheet. I hope that makes sense. So e.g in the May sheet copy over a cell from April and then add to that from a cell in May, in the next month it would copy over from the May and add from a cell in June.
What I would like to know is if there is some kind of formula which would know to always copy a cell from the previous sheet?
I'm not an expert in Excel, but if anyone can shed some light on this it would be very helpful.
Copying number over from last sheet and adding to it