Pam,

Thanks for the example. This is basically what I want to create.
However, because the spreadsheet is a living document and changes
regularly, rows can be iserted several pages back causing page break
locations to change resulting in the improper placement of the totals.

What I am looking for may be way too complex to empliment if it is even
possible.

Thanks for the help,

Steven