How do I copy subtotals to another sheet?
 

When I collapse into level 2, I need to copy just the totals into another
sheet. Does anyone know how to do this w/o getting all of the intervening
rows?

Thanks..........Alisa

Hi
- select your data range
- hit F5, click 'Special' and choose 'Visible cells only'
- now copy+paste

--
Regards
Frank Kabel
Frankfurt, Germany

"Alisa" schrieb im Newsbeitrag
...
When I collapse into level 2, I need to copy just the totals into
another
sheet. Does anyone know how to do this w/o getting all of the
intervening
rows?

Thanks..........Alisa