Adjust the subtotals to your liking, select the range, press F5 and select
special and visible cells only
copy and paste

--

Regards,

Peo Sjoblom


"Greg glenn" <Greg wrote in message
...
How do I paste subtotals only of a list into another worksheet without the
background data?