Copying Subtotals

[Ray Kanner]

I have a sheet to which I've applied the Subtotals
command. I can click on the outline symbols to see just
the rows with the subtotals but would like to take just
those subtotal rows and copy their values to another
sheet. How can I do that?

Thanks

Ray Kanner

 

[Peo Sjoblom]

Select the visible part that you want to copy, press F5, click special and
select visible cells only,
copy and paste