How do I copy/paste subtotals without all the extra data?

[climberboy]

I am trying to either do a vlookup or copy and paste the subtotals without
getting all the data in the hidden rows?

[tchen]

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 highlight with white lines the subtotals you want to copy. then ctrl V to wherever you want. it'll get rid of all the data in the hidden rows and leave only the subtotal results.

2. copy and paste from Excel into Word and back again. That should do the trick.

3. Copy and paste your subtotals normally. When it's expanded, sort with using one of the empty columns. At the bottom should be all the cells with "total" from the subtotal function. Any cell above were hidden previously....which you can now delete.

I hate deleting data when it's not really necessary. if you do, I suggest you backup your data before doing any deleting.