excel worksheet

[cabnett]

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.

[kempie]

Select the cell which contains the total and click Copy.

In the next worksheet select the cell where you wish the total to be carried forward and click Edit → Paste Special... → Paste Link

[craft1948]

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?

[ACtheTROLL]

kempie has it

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

then in row 101 enter the sum formulas again

then in sheet 3
=Sheet2!$b$101
=Sheet2!$c$101

and so on

if you then want a 12 month total
in sheet 13

=Sheet1!B101+Sheet2!B101 .... etc