EXCEL COPY SUBTOTALS TO ANOTHER WORKSHEETWITHOUT INCLUDING DETAIL

[BobbyD]

I have a significant amount of data that I have subtotaled in excell. I
would like to copy (and use) the subtotals only in another excell
spreadsheet...but when I try to copy and paste I continue to get the detail.
How can I copy just "what I see" on the subtotals worksheet ?

 

[Debra Dalgleish]

Select all the cells that you want to copy
Choose Edit>Go to, and click the Special button
Select Visible Cells Only, and click OK

Choose Edit>Copy, then paste the cells.