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