data subtototals

[russell]

I can subtotal a sheet but when I try to copy the
subtotal summary figures, it copies everything. Is there
any way to just copy whats on the sheet and not
the "missing" cells?

 

[David Hager]

Use Edit Goto Special and select Visible Cells only before copying.