Louise,

It certainly is possible!
Select the entire area you wish to copy
CTRL +G and click Special
Select the "visible cells only" option and press OK
When you copy and paste only the visible results of your subtotals
will appear.

regards,

Stevne