Sub Totals

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

Guest

I frequently use the Data/Subtotals feature in Excel.
After forming the subtotals, I would like to work on them alone without the
underlying data showing up.
Is there any way to extract the Subtotals ONLY to another worksheet and to
leave the Pre-Subtotal data behind so that it does not interfere?

Thanks for your help

Henry
 
Select the range you want to copy, press F5, then click special and visible
cells only, now copy and paste. That will exclude hidden rows


--


Regards,


Peo Sjoblom
 
Peo Sjoblom said:
Select the range you want to copy, press F5, then click special and visible
cells only, now copy and paste. That will exclude hidden rows


--


Regards,


Peo Sjoblom






Peo,
Click to expand...

You are a genius.

That works perfectly. I have never seen "Visible Cells Only".

You solved my problem.

Many thanks

Henry
 
Peo,
You are a genius.

That works perfectly. I have never seen "Visible Cells Only".

You solved my problem.

Many thanks
Click to expand...


Thanks for the praise Henry, although I am not a genius it's good that you
post back to verify that the solution works

Peo
 
Thanks for the praise Henry, although I am not a genius it's good that you
post back to verify that the solution works

Peo
Click to expand...

Thanks a lot! You saved me many troubles!
:bow: :)

Marina
 
Back
Top