How do I copy/paste subtotaled data

[JDS]

so that only the subtotals paste and not all the line item detail?
jds

[RagDyer]

Collapse the list and then select all the cells that you wish to copy.
Hit <F5>, <Special>,
Click "Visible Cells Only", then <OK>.
Right click in this selection and choose "Copy".
And then paste it wherever.

Don't paste it in an area of the sheet which might have some rows hidden due
to the SubTotals.


HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"JDS" <[email protected]> wrote in message
news:1108074735.565056456c7b958206c88e04ef01ad46@teranews...
so that only the subtotals paste and not all the line item detail?
jds

[Micah Chaney]

I'm not entirely sure of what you're asking...but if you right click where
you want to Paste and choose Paste Special. A menu will appear, choose
paste value.

Hope this helps.

"JDS" <[email protected]> wrote in message
news:1108074735.565056456c7b958206c88e04ef01ad46@teranews...
> so that only the subtotals paste and not all the line item detail?
> jds
>
>

[JDS]

Thanks!

"RagDyer" <[email protected]> wrote in message
news:[email protected]...
> Collapse the list and then select all the cells that you wish to copy.
> Hit <F5>, <Special>,
> Click "Visible Cells Only", then <OK>.
> Right click in this selection and choose "Copy".
> And then paste it wherever.
>
> Don't paste it in an area of the sheet which might have some rows hidden
due
> to the SubTotals.
>
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
> "JDS" <[email protected]> wrote in message
> news:1108074735.565056456c7b958206c88e04ef01ad46@teranews...
> so that only the subtotals paste and not all the line item detail?
> jds
>
>

[yahoo]

Hi

This works well - but
when you subtotal excel inserts the word 'total' on the same line -

How can I remove the word total?

In my case I am subtotaling by invoice number - after I subtotal it
states '123456 total' - 123456 = invoice number

When I do the special copy/paste below the '123456 total' is pasted on
a new line - but I cannot have the word total there - becuase I need
to upload the invoice number as format number into another program

How can I get rid of the word total?

Thanks

On Thu, 10 Feb 2005 15:20:38 -0800, "RagDyer" <[email protected]>
wrote:

>Collapse the list and then select all the cells that you wish to copy.
>Hit <F5>, <Special>,
>Click "Visible Cells Only", then <OK>.
>Right click in this selection and choose "Copy".
>And then paste it wherever.
>
>Don't paste it in an area of the sheet which might have some rows hidden due
>to the SubTotals.
>
>
>HTH,
>
>RD
>==============================================
>Please keep all correspondence within the Group, so all may benefit!
>==============================================
>
>"JDS" <[email protected]> wrote in message
>news:1108074735.565056456c7b958206c88e04ef01ad46@teranews...
>so that only the subtotals paste and not all the line item detail?
>jds
>

[Ragdyer]

Have you tried the "old stand-by", Edit - Replace?

Select the column containing the "123456 total",
<Edit> <Replace>,
Enter "total" (no quotes) in the "Find What" box,
Don't enter anything in the "Replace With" box,
Then click "Replace All", and you should have the display you're looking
for.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"yahoo" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> This works well - but
> when you subtotal excel inserts the word 'total' on the same line -
>
> How can I remove the word total?
>
> In my case I am subtotaling by invoice number - after I subtotal it
> states '123456 total' - 123456 = invoice number
>
> When I do the special copy/paste below the '123456 total' is pasted on
> a new line - but I cannot have the word total there - becuase I need
> to upload the invoice number as format number into another program
>
> How can I get rid of the word total?
>
> Thanks
>
> On Thu, 10 Feb 2005 15:20:38 -0800, "RagDyer" <[email protected]>
> wrote:
>
> >Collapse the list and then select all the cells that you wish to copy.
> >Hit <F5>, <Special>,
> >Click "Visible Cells Only", then <OK>.
> >Right click in this selection and choose "Copy".
> >And then paste it wherever.
> >
> >Don't paste it in an area of the sheet which might have some rows hidden
due
> >to the SubTotals.
> >
> >
> >HTH,
> >
> >RD
> >==============================================
> >Please keep all correspondence within the Group, so all may benefit!
> >==============================================
> >
> >"JDS" <[email protected]> wrote in message
> >news:1108074735.565056456c7b958206c88e04ef01ad46@teranews...
> >so that only the subtotals paste and not all the line item detail?
> >jds
> >
>