Excel - Page Break after grouping

[apoena]

Can anybody tell me if there's a way to set up page breakes after each group in Excel? I have a report that comes out of SAP in Excel format with the data set up in groups (as in <Data><Group and Outline><Group...>). Is there a standard funcion where I can do that or is there a workaround using VBA? Anybody?

Thanks!

 

[lhite]

The only way that I know would be to manually put the breaks in, either using INSERT, PAGE BREAK, or Page Break Preview right clicking and choosing INSERT PAGE BREAK.

-Larry

 

[schat]

apoena
not sure if this will do the job, but according to this thread:

http://216.92.17.166/board/viewtopic.php?topic=27623&forum=2

there is a page break option in the subtotals function (data menu).
hth

 

[RobBroekhuis]

You can certainly use VBA to do just about anything you'd want. If you're interested in taking that approach, your best bet is to specify your problem in more detail on the VBA forum here.
Rob