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

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

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.


--
tchen
------------------------------------------------------------------------
tchen's Profile: http://www.excelforum.com/member.php...o&userid=26060
View this thread: http://www.excelforum.com/showthread...hreadid=394045