View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default paste only subtotals, not individual date that makes up subtot

Try hiding the details
then select the range
and then one more step
edit|goto|special|visible cells only

Now do the edit|copy and edit|paste.



judybart wrote:

where is the subtotal copy?- if i use the regular copy & paste special
-values i still paste all the supporting date not just the subtotal rows

"Marcelo" wrote:

Hi Judy,

select the subtotals copy and paste special as values



"judybart" escreveu:

i only want to copy & paste the subtotals, not the supporting data

thanks


--

Dave Peterson