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.
|