Excel - copy subtotal rows only

G

Guest

I have data in multiple colums that has been subtotalled by the sum function.
I now wnt to copy and paste or export only the rows containing the subtotals
to a new sheet. When I do this I get all the rows! It does work if I use the
CNTRL key to mark all the individual cells and then paste values only but I
find this a dreadful solution. Surely there is an easier way?
 
G

Guest

One way:
click the 2 in the outline box to hide the data rows
Highlight the range of subtotals
F5>Special>click on visible cells only
Copy>Paste Special>Values
HTH
 

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

Fill down visible cells only 4
Conditional SUBTOTAL in XL210 Table 7
Quick/efficient way to VBA subtotal 2
Copying only subtotals 1
subtotal copy and paste 3
subtotal titles 1
Subtotals 2
Copying from Subtotal Data 2

Top