View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lang Lang is offline
external usenet poster
 
Posts: 1
Default How do I copy a range in Excel without including hidden rows?

I am using Excel 2002. I have created subtotals on a worksheet. I can view
the worksheet and see only the subtotals (the data records are hidden). I
would like to create another worksheet consisting of just the header and
subtotals from the first worksheet.