Paste Subtotal's only into new sheet

  • Thread starter Thread starter Carla
  • Start date Start date
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?
 
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
 
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)
 
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...
 
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...
 
Back
Top