Mr Brain, A macro can be written such that
1. It will copy certain number of rows (one page full) to another sheet (example sheet2) 2. In sheet2 it will be formatted for printout (such that C/F, B/F, Page header, Page footer etc.) (counters will be maintained for page numbers, C/F, B/ F ............) 3. the page will be printed 4.Repeat the process till all 10,000 rows are over If you won't get reasonable solution from others, U can send me the file to my mail ID. I can construct the macro and send it to you. Regards, Kishan Reddy kishanreddy.kethire...@gmail.com On Oct 7, 12:26 pm, fill brain <fillbr...@gmail.com> wrote: > Hello , > > i mean i want to see to totals on custom footer.. like below excel > file.. i wrote "xxx" which place i want to write footer total.. my > intention. > > that is file... ornek.xls i added it in the group > files.http://excel-macros.googlegroups.com/web/ornek.xls?gda=e7Xufj4AAAAo61... -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
