I want to paste the results of a subtotal into another worksheet in a book.
How can I paste just the subtotaled info wothout all of the drilldown info it
is based on. I have tried Paste/Values only etc. No Luck. The only thing I
have found that works is pasting to a text file, then copying and pasting
that back into Exel. Is there an easier way? I do this about 30 times a day
and it seems like it should be easier!!

Thanks,
Tom