View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DBergesen
 
Posts: n/a
Default How do I copy subtotaled data without the underlying details?

I want to copy the subtotaled data to another part of the worksheet or a new
worksheet without the underlying details. If I click and drag the area I want
to copy it picks up all the hidden rows. I don't want them.