Copy Sub Totals
 

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

Copy Sub Totals
 

Do you just want the values, not the formulas behind them? Then just select
Edit--Paste special--values.
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"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

Copy Sub Totals
 

Dave F I had tried that. Let me clarify...the subtotals are grouped on
the left of the worksheet there is an + . When I copy to a new worksheet it
is still grouped all I want is the totals


"Dave F" wrote:

Do you just want the values, not the formulas behind them? Then just select
Edit--Paste special--values.
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"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

Copy Sub Totals
 

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

Copy Sub Totals
 

Dave Super! thank sooo much

"Dave Peterson" wrote:

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