subtotal copy and paste

H

Hager

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
 
Y

Yanick

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.
 
D

Dave Peterson

After you hide the rows you don't want to see, hit F5 (or ctrl-g) or Edit|Goto
(in xl2003 menus).

Then select the range you want to copy (including both the hidden and visible
rows).

Then click the Special button
choose Visible cells only.

Copy those visible cells and paste (paste special|values???) to the new
location.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top