Fantastic! I knew there must be a way, I never thought of that.

Thank you.
Louise

"Steven" wrote:

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