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.
 

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

copy and paste if 1
subtotal copy and paste 3
Copying from Subtotal Data 2
Getting Text data using the Data - Subtotal feature 1
Conditional SUBTOTAL in XL210 Table 7
Subtotals in Excel 2003 with Autofilter and Grouping 3
Multiple formulas in subtotal 2
SUBTOTAL and 9 1

Top