ExcelBanter - subtotal

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - subtotal (https://www.excelbanter.com/excel-discussion-misc-queries/194948-subtotal.html)

Mark

subtotal

After i have Subtotaled a spreadsheet, then collapsed to show subtotals can I
copy just the subtotal

Bernie Deitrick

subtotal

Mark,

Select the cells, then use Edit / Go to... Special Visible Cells Only, OK, then copy and
paste.

HTH,
Bernie
MS Excel MVP

"Mark" wrote in message
...
After i have Subtotaled a spreadsheet, then collapsed to show subtotals can I
copy just the subtotal

All times are GMT +1. The time now is 02:34 PM.