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.



Gerrym wrote:

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

TKS

--

Dave Peterson