View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SBoak SBoak is offline
external usenet poster
 
Posts: 2
Default Sub-Totals Question

Hi Folks:

I have a small sheet of about 150 rows and 25 columns that represent sales
results.
I have a report set up in Sub-Totals, and I'd like to just copy the Total
data.
But when I copy and use Paste or Paste-Special, all the rows that are hidden
get un-hidden . . .
Is there a way to just get the sub-totals to paste ??

Thanks Much
Steve