Thread: How do I copy sub total data only onto a new worksheet?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
  
Posts: 3,346
Default How do I copy sub total data only onto a new worksheet?
Hi,

Select your data and press F5, Special, Visible cells only, OK. Then copy.

If this helps, please click the yes button

Cheers,
Shane Devenshire

"khuff" wrote:

When subtotaling a large amount of data I would like to be able to copy and
paste just the subtotal-ed information. When I try to do this I cant figure
out how to eliminate the underlying data from copying too.
Reply With QuoteReply With Quote