Paste Subtotal's only into new sheet

[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?

 

[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

 

[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)

 

[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





.

 

[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





.

 

[Peo Sjoblom]

Thanks for the thanks..


Peo Sjoblom

YOU ARE AWESOME!!!
THANK YOU!

 

[Guest]

Genial! Thank you.

-----Original Message-----
YOU ARE AWESOME!!!
THANK YOU!

.