Copy and paste when using subtotal

[Tom]

When I am using the data, subtotal options and I collapse
the data to only see the subtotals - I would like to copy
and paste only those rows. However when I copy and paste
all of the collapsed rows come over. How can I only get
the subtotal rows??? Help

Thanks,
Need for a class tomorrow

 

[Peo Sjoblom]

Press F5, click special, select visible cells only, copy.

 

[Dave Peterson]

Right before you do a copy
Edit|goto|Special
visible cells only

Then copy|paste.