You can select the data, press F5, click special and visible cells only,
then copy and paste

--
Regards,

Peo Sjoblom


"Jenny" wrote in message
...
When I subtotal a spreadsheet and view my results by clicking on the
little
#2 in the top corner is there an easy way I can select just this data and
cut
and paste the values into a new worksheet. Thanks