Copy and paste when using subtotal

T

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
 
D

Dave Peterson

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

Then copy|paste.
 
Top