Hi, I used the subtotal feature to force page breaks after each of my subtotaled groups. Works fine and in Print Preview I see each set of data on its own page.
Is there a way to have Excel create multiple worksheets where there are page breaks and force the data between breaks over to the new sheet? Either manually or via macro or other means. I know I can copy/paste the data between the breaks over to new sheets, but this is very tedious on a really long subtotaled sheet.
TIA!-Brian
</PRE>
Is there a way to have Excel create multiple worksheets where there are page breaks and force the data between breaks over to the new sheet? Either manually or via macro or other means. I know I can copy/paste the data between the breaks over to new sheets, but this is very tedious on a really long subtotaled sheet.
TIA!-Brian
</PRE>
