paste only subtotals, not individual date that makes up subtotal

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

thanks
 
Hi Judy,

select the subtotals copy and paste special as values



"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
 
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.
 
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:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Additonal info into newly created Subtotal row 1
Don't show all Pivot table subtotals 1
subtotal, match? 10
Subtotal of adjacent coloumn 4
Subtotals copy paste 1
SubTotal 1
Formulas in subtotal worksheets? 3

Back
Top