Paste Subtotal's only into new sheet

C

Carla

I have a long list of detail that I have subtotaled.
Now, I need to take the subtotal info(not the detail) to
a new sheet. I have tried copy/paste, but that pastes
all detail hiding behind the subtotals. How can I
accomplish this?
 
P

Peo Sjoblom

Select the range, press F5, click special and check visible cells only
OK. Now copy and paste

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
H

hcj

Thanks for the question! I need a better answer myself.
All I've been able to figure to do is select the
individual subtotal rows (or cell areas) first using
Ctrl+select, then copy, then paste.
I'll be looking for a better response from someone else!
HTH (a little)
 
C

Carla

YOU ARE AWESOME!!!
THANK YOU!
-----Original Message-----
Select the range, press F5, click special and check visible cells only
OK. Now copy and paste

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom





.
Click to expand...
 
H

hcj

Excellent! Thank you!
hcj
-----Original Message-----
Select the range, press F5, click special and check visible cells only
OK. Now copy and paste

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom





.
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

Combine Sumifs with Subtotal 0
Additonal info into newly created Subtotal row 1
Can I use the subtotal function while a worksheet is protected? 0
I need ONLY subtotals copied to a second sheet 4
Copy summary data to new sheet 1
Excel 2007 - Outline not displaying all nested subtotals 0
Subtotal 3
Getting Text data using the Data - Subtotal feature 1

Top