I use the Subtotals command from the Tools Menu and then use the Outline Bar
to collapse my list so that only the subtotals and grand totals are
displayed. I then want to be able to copy only that information. If I copy
and paste I get all the intervening rows and if I copy and paste special only
values I still get all the intervening rows.

Is there a way to do this?

I am using 2003