How do I selectand copy only subtotals in a sheet

[Select and copy only subtotals in sheet]

How do I select only all subtotals in asheet and copy them into another
sheet .As there are many subtotals in a sheet , selecting subtotalsone by one
is not the easy way.

 

[Stefi]

Why don't you make a search with keywords "copy subtotals? You will find such
posts:

"Hi
when only showing subtotals only level select edit go to special select
visible cells only click ok then copy this data paste on new sheet
Tina"

Regards,
Stefi




„Select and copy only subtotals in sheet†ezt írta: