Cut and Paste Subtotals

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

When I run subtotals sometimes I need to transfer the
subtotals to a new worksheet to run different formula's on
them. The only way I seem to be able to cut and paste
them to another work sheet without getting all the detail
lines is to use the control key and select them with my
mouse. Is there some way I can just select the subtotals
and paste the values to another worksheet. The way I am
doing it now seems awful tedious

Dan
 
Hi Dan

:) been there :)

click on the outline numbers so that only the subtotals are showing,
select the subtotal labels & values
choose Edit / Goto / Special / Visible cells only
choose copy
go to destination
choose edit / paste


Cheers
julieD
 
Worked Great, Thank you very much !
-----Original Message-----
Hi Dan

:) been there :)

click on the outline numbers so that only the subtotals are showing,
select the subtotal labels & values
choose Edit / Goto / Special / Visible cells only
choose copy
go to destination
choose edit / paste


Cheers
julieD






.
Click to expand...
 

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

Additonal info into newly created Subtotal row 1
cut and paste subtotal from excel 1
need help on either doing a loop and counting specific values orusing subtotal function 2
subtotal, match? 10
SubTotal 1
Multiple Subtotal Placement 2
Subtotals copy paste 1
Formulas in subtotal worksheets? 3

Back
Top