Write subtotals to another sheet

G

Gerrym

when I apply subtotals to data in a sheet can i write the
results from level 2 to another sheet ?

TKS
 
D

Dave Peterson

Show the levels you want to copy (hide the other details).

Create a new worksheet

Back to the subtotal worksheet
Select that range
edit|goto|special
check visible cells only
copy that selection of visible cells.

Paste into that new worksheet.
 
Top