Excel, how copy subtotals without copying all lines inbetween?

G

Guest

In Excel, once I have used the subtotal function, how can I copy and paste
the subtotals into a new worksheet or new file without also copying all the
inbetween lines?
 
G

Guest

Try this:

Hide the detail rows
Select the range you want to copy
Edit>Goto>
Click the [Special Cells] button
Select: Visible Cells

Edit>Copy

Go to the destination range
Edit>Paste Special>Values

Is that what you're looking to do?

***********
Regards,
Ron
 

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

Copying only subtotals 1
Copy within a subtotal 1
subtotal copy and paste 3
copy and paste if 1
Getting Text data using the Data - Subtotal feature 1
Conditional SUBTOTAL in XL210 Table 7
Using Subtotals in Other Sheets 7
subtotal titles 1

Top