How can I have a carried forward total in Excel

[TracyK]

I have an 11 page spreadsheet to submit to Inland Revenue which requires subtotals at the bottom of every page.
Do I have to work out my page breaks and totals manually or is there an easy way for it to work out where to chop pages and pop a carried forward total in?

Hi - You can insert page break automatically - but I don't think it can recognise sub totals at the bottom of a page. If you want to send me the template - take the details off - then I'll happily formulate for you (bit bored in work today !) and I love an excel challenge (read 'geek' !). For now, go into "View" and select "Page Break Preview" this will show you where the page breaks are. You can move the blue lines around wherever you want if you want to ammend the page breaks - however, excel cannot automatically recognise a subtotal based on page split.
Hope this helps you for now !

Thanks Imagine.

I lost internet connection earlier - just back on now.

I gave in and just manually totalled the pages and moved the page breaks around.

You can use Data/Subtotals to give a total when a column value changes, and there is a "page break between groups" option. You might need to add a new column to force the page breaks where you want them (e.g. a column called 'page number').

I tried that ClerkKent and it was sucessful when I put a column for page 1 ie all '1' down to the page break and then '2' on the next page - all went well but then when I put in '3' - it ignored the 3's - so after a bit of faffing - I gave up!

Fair enough, it was only 11 pages.