Copying Only Collpsed Results From a Subtotal

[tomwilson64]

I just learned to use the Subtotal button from the Data tab in Excel 2007. I'm using a small sample set to get a feel for it. When I complete the subtotal and collapse all the groups, I have just the data I want. I highlight it and copy it, but when I paste it, I get all the data from the collapsed lines as well as the subotal lines themselves.

How can I copy the collapsed info and paste only what is showing when collapsed so the detail from those visible rows is all that is pasted?

Tom

 

[Nalani]

Try PasteSpecial and choose All Using Source Theme

 

[RoryA]

Select the data, press Alt+; and thn copy and paste.