Hide the details
Select the range to copy
Edit|Goto|Special|Visible cells only
Edit|Copy

and then off to the new location
edit|paste



Wanna Learn wrote:

Hello I have a worksheet with subtotals. ( I used data - subtotals to
create the subtotals) I copied the subtotals to a new worksheet everything
else is copied. All I need is the subtotals only thanks

--

Dave Peterson