EXCEL COPY SUBTOTALS TO ANOTHER WORKSHEETWITHOUT INCLUDING DETAIL
 

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 ?

EXCEL COPY SUBTOTALS TO ANOTHER WORKSHEETWITHOUT INCLUDING DETAIL
 

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

Choose EditCopy, then paste the cells.

BobbyD wrote:
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
Contextures
http://www.contextures.com/tiptech.html