I'm using Excel 2003 and Windows XP Pro.
I'm using a list of accounts that I've sub-totaled by using the buttons in
the top left to compress the rows to show only the sub-totals. I want to
copy that list of sub-totals and only the sub-total data. Every time I try
to copy and paste or paste special, I get all the uncompressed rows. I only
want to have the sub-totals as data that I can then manipulate the sub-totals.
I hope this question is not too unclear, because I'm really stymied and need
help on this!!