ExcelBanter - Working with sub-totaled data

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Working with sub-totaled data (https://www.excelbanter.com/excel-worksheet-functions/37575-working-sub-totaled-data.html)

itchy777

Working with sub-totaled data

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.

Ray A

One way
Collapse the sutotals and highlight. F5Specialvisible cells onlycopypaste
HTH

"itchy777" wrote:

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.

All times are GMT +1. The time now is 05:39 PM.