Working with sub-totaled data

I

itchy777

How can I work with sub-totaled data without all of the detail. If I do a
sub-total on column 6, collapse the data then sum the column, all of the
detail is used in the calculation. If I try to copy it to a new sheet, or
workbook all of the detail comes along.

The only way I've been able to work around this is to copy the sub-totaled
data to Word and then copy it back to Excel.
 
R

Ray A

One way
Collapse the sutotals and highlight. F5>Special>visible cells only>copy>paste
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

Need Help with a VBA subroutine 0
List all tables, including document structure 0
Calculate Total Hours when Overlapping Occurs 0
Time Sum in Excel 1
Auto Sum not working correctly 1
Sumif apllying to all sheets in workbook 2
How do I copy and paste only the sub-total from a list 3
Help with a running total on multiple sheets 2

Top