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
|