View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default How do I selectand copy only subtotals in a sheet

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:

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.