How do I copy subtotals to another sheet?

A

Alisa

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
 
F

Frank Kabel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Copy addition formula of non-consecutive horizontal cells 2
Copy summary data to new sheet 1
Copy entire row from another sheet onto first sheet if a unique text matches 1
can i automatically copy subtotals in excel to another s/sheet? 1
Visio: copy text of a master shape to User-define Cells (Variable) 0
Making a Sheet copy 3
Dealing with a Pivot Table (when I don't want to) 0

Top