Copy only subtotals in excel

Short summary:

a) edit->goto and then select visible cells to select only visible ones.

b) You can pick the "select visible cells" menu item (tools->customize) to your toolbar.

c) Highlight the region, press Alt-; (semicolon) and then Ctrl-C. to copy only visible cells.