View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
khuff khuff is offline
external usenet poster
 
Posts: 11
Default How do I copy sub total data only onto a new worksheet?

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.