print a total on every printed page in excel

[zapster]

Hi All,

I have a excel spread sheet with sales figures on for each of our customers. When printing it of it goes over several pages.

Does anybody have a 'macro' or quick method that will automatically insert a page total on every page and print of the page. I know that currently it prints off about 50 rows on every page if this is any help

Please let me know.

Thanks

zapster

 

[SkipVought]

Hi,

What is the purpose of a page total on each sheet? Does it have any significance?

Is the Page Break on some row grouping -- like Region A is on Page 1, so the Region A totals are whatever. That can be done with the Subtotal Wizard.

Why not put the COLUMN TOTAL at the TOP of each sheet so the user does not have to hunt for the last sheet to discover the "bottom line"?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[zapster]

Hi Skip,

The purpose of the sub total on the printout is so that we can just keep track of our figures when checking them off.

the report is just continous on one sheet ie one month is can be 1000 rows and the next 3000. so when we print it off we normally add up each page manually but mistake can be made. This is why we would like a automatic system to addup a page total before it is printed.

Unfortunally the data is not in any grouping and I have had a go with subtotal wizard but this just total every x,y,z.... row which doesn't help. In theory we would like a total every 50th row and then to have a page brake.

can this be done?

Thanks for your help

zapster

 

[SkipVought]

Why are you using an ADDING MACHINE?????

Excel does arithmetic FLAWLESSLY!

I can see you checking the VALUES that were entered on the spreadsheet but NOT the TOTALS!

I can't believe it!

Yes, you can construst an expression that would return a value that would change every nth row and then subtotal break on that value.

=INT((ROW()-1)/$G$1)

where G1 contains the number of rows per page.

But my question still stands. Why are YOU adding columns? Why isn't Excel summing the entire column?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[zapster]

Skip,

I do have a grand total at the very bottom.

Where would i imput your formula =INT((ROW()-1)/$G$1)
if columns A,B,C,D and E are being used

Thanks

zapster