Sub Totals


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
 
Ad

Advertisements

P

Peo Sjoblom

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
 
G

Guest

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,

You are a genius.

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

You solved my problem.

Many thanks

Henry
 
P

Peo Sjoblom

Peo,
You are a genius.

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

You solved my problem.

Many thanks


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
 
Ad

Advertisements

M

miss.milojevic

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 a lot! You saved me many troubles!
:bow: :)

Marina
 
Ad

Advertisements


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

subtotal titles 1
Sub-Totals Question 2
Presenting Subtotals only 2
Sub total sorting 1
Sub totals 1
Pivot Table-Multiple Consolidation Ranges 3
Graphing Subtotals 1
Subtotals Don't Collapse Correctly 1

Top