Smart footer

[pkrbff]

I use excel to generate bills of
quantities for Construction jobs. Those
are long list of items that typically span
several pages. I would like a summation
for each page to be made in the
page's footer (or last row). This needs to
be smart enough to avoid re-work in case
items are inserted in the sheet.

Any ideas?

 

[Dave Peterson]

It sounds like you could use Data|Subtotal. There's an option in that wizard
that allows you to put the subtotals at the bottom and put each group on its own
printed page.

I usually remove the subtotals and reapply them, but if you're careful, you may
be able to just insert new rows in your data.