Is there a way to subtotal to seperate sheets in excel?

E

Eric Pulliam

I need to find a way to place subtotals on seperate pages. Copy and paste
1000 times over takes hours too long. Any help would be greatly appreciated!

Thanks!
 
D

Duke Carey

What do you mean, placing subtotals on separate pages?

Have you used Excel's subtotal command to create the subtotals? Collapse
the view down to just the subtotal rows. Now select those rows and press the
F5 key & click on the Special button. Choose 'Visible cells only' & click on
OK

Now copy the selection, move to the other sheet, and paste
 
Top