Sub-Totals to Summary?

From: Dan (dan_at_nospam..com)
Date: 12/30/04 

Date: Thu, 30 Dec 2004 10:18:58 -0600

Hi,

I am trying to summarize row data by a field. I sub-total then I
collapse the the outline to get my summary. But then I want to copy
this summary to a new work*** without the supporting details. When I
Paste Special it Excel still includes the data that was sub-totaled.
Can someone help me?

TIA,
Dan