paste only subtotals, not individual date that makes up subtotal
 

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

thanks

paste only subtotals, not individual date that makes up subtotal
 

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

paste only subtotals, not individual date that makes up subtot
 

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

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

paste only subtotals, not individual date that makes up subtot
 

Ok Judy, you are coping the entire figures, as the rows are hiding,
try to select the area, press F5 click on the Special botton, select visible
only.

hope this helps
regards from Brazil
Marcelo

"judybart" escreveu:

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