Manually every page break insert row than subtotal is difficult ,if many page in a report. Lastly grand total in last page time waste because Scrolling tab and go to last page . I search this easy way it solve but not find in net .Find one thing but it open another page and subtotal not header row repeat.So , I try and success .At first page set up and paper size select then click button or macro with in second all page break insert a row where page break then subtotal in this inserted row and last page grand total in two row for confirmation . Last row grand total delete manually If you confirm this two grand total same . For all thing I use Vb code. This Vb code is..

Categories

Translate

Post Archive

Follow me

Subscribe via E-mail

Recent Post

I hope all my Posts is useful for all of you. Thanks for visit here and support me. All of my Tutorial and Post licensed under a Creative Commons Attribution 3.0.license.If you have any problem with any topic or want to give any new ideas and suggestions about this blog then you can Contact with me freely.About me |See more...