SubTotals

[Bill]

Hello,
After adding subtotals to a table and collapsing the table to view the
totals, is there a way to copy the totals only to a new worksheet? When I
select the rows, I end up copying everything to the new worksheet.

Thanks.

Bill

 

[Frank Kabel]

Hi after collapsing and selecting the range try:
- hit F5 and click 'Special'
- choose 'Only visible cells'
- copy and paste the range