Hi

I have used the subtotal option in Excel and this is fine. I have also
collasped the list so only the subtotal for each category is visible. However
I want to copy and paste this list (just the subtotal) into another sheet

When I do this it expands and shows all the results. Is it possible to just
copy the visible bit. I have looked in paste special but no luck

Cheers Hager