number of ways you can do this...i had the same question earlier.
1. highlight the subtotals results that you want to copy. hit F5
special and "visible cells only" then ctrl C, which sould highligh
with white lines the subtotals you want to copy. then ctrl V t
wherever you want. it'll get rid of all the data in the hidden row
and leave only the subtotal results.
2. copy and paste from Excel into Word and back again. That should d
the trick.
3. Copy and paste your subtotals normally. When it's expanded, sor
with using one of the empty columns. At the bottom should be all th
cells with "total" from the subtotal function. Any cell above wer
hidden previously....which you can now delete.
I hate deleting data when it's not really necessary. if you do,
suggest you backup your data before doing any deleting
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.
