hi New to excel worksheets and doing my husbands accounts. I have managed to work out some of the formulae i need but can't work out either how to carry totals forward from one worksheet to another or how to bring the figures forward, whichever is the best way to do it. Any help would be greatly appreciated.
in sheet 1 I assume you will have totals formula set up - so for instance if you want to carry forward totals from the bottom of column F go to sheet 2 click on top cell of column F and do = then go back to sheet 1 click on the total in column F and press the tick button at the top. This will save you copying and pasting as it links the sheets through and the figures on sheet 2 will change as the figures on sheet 1 are altered - does that make sense?
I generally just go to sheet 2 type =
and then just switch back to sheet 1 and click on the cell you want to "bring forward"
but if you want to create template set of 12 sheets
the easiest way is to format the links
so every sheet looks the same
frinstance
if col a is category
b is credit
c is debit
if you assume no month will have more than 98 entries
with row 1 used for headings
sheet
in b101 enter =sum(b2:b100)
in c101 =sum(c2:c100)
in sheet 2
in b2 enter =Sheet1!$b$101
in c2 enter =Sheet1!$c$101