ExcelBanter - how do i copy the subtotal lines only without the details?

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

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

- - how do i copy the subtotal lines only without the details? (https://www.excelbanter.com/excel-discussion-misc-queries/176433-how-do-i-copy-subtotal-lines-only-without-details.html)

jimmysyf

how do i copy the subtotal lines only without the details?

Dave Peterson

how do i copy the subtotal lines only without the details?

Collapse the table to show just the subtotals
Select the range to copy
Edit|goto (or ctrl-g or F5)
Visible cells only

copy and paste elsewhere.

jimmysyf wrote:

--

Dave Peterson

All times are GMT +1. The time now is 10:07 PM.