On Jan 21, 6:38*am, Hager wrote:
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

Copy the subtotal result then paste special (values) in a other sheet.
Then filter the list to : Does not Contian "total" and delete all
those rows. Only what you need should be left over. You can then find
& replace " Total" for "".

That will do the tirck.