Copying Subtotals?

[Robin Funnell]

How do I copy just the subtotal information to a new worksheet?

[Aloysicus]

Hi Robin,

If you are just copying the information over, just copy it and on the new
worksheet, do a paste special onto it

Aloys
"Robin Funnell" <Robin Funnell@discussions.microsoft.com> wrote in message
news:FE504B23-96FB-4B0F-9D9F-366B1E8B1A7E@microsoft.com...
> How do I copy just the subtotal information to a new worksheet?

[vanjohnson]

On your subtotaled page, summarize to the level that you want to copy (by
clicking on the numbers on the upper left).

Select all of the rows. Then select Edit - Go to, hit the "Special Button"
and then "Visable Cells Only".

You now can go to where you want to paste, and do paste special, values.



"Robin Funnell" wrote:

> How do I copy just the subtotal information to a new worksheet?

[yahoo]

Hi

This works well - but
when you subtotal excel inserts the word 'total' on the same line - as
in theis example 'company name'

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 Tue, 4 Jan 2005 12:43:05 -0800, "vanjohnson"
<vanjohnson@discussions.microsoft.com> wrote:

>
>On your subtotaled page, summarize to the level that you want to copy (by
>clicking on the numbers on the upper left).
>
>Select all of the rows. Then select Edit - Go to, hit the "Special Button"
>and then "Visable Cells Only".
>
>You now can go to where you want to paste, and do paste special, values.
>
>
>
>"Robin Funnell" wrote:
>
>> How do I copy just the subtotal information to a new worksheet?

[CLR]

Highlight the column with the word "total" in it, then
Edit > Replace > Find What: Total > Replace with: (leave blank) > ReplaceAll
button

Vaya con Dios,
Chuck CABGx3

"yahoo" <nj530@yahoo.com> wrote in message
news:u88t01pqjg5s57s7gntlmpcr3j8cfi3mru@4ax.com...
> Hi
>
> This works well - but
> when you subtotal excel inserts the word 'total' on the same line - as
> in theis example 'company name'
>
> 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 Tue, 4 Jan 2005 12:43:05 -0800, "vanjohnson"
> <vanjohnson@discussions.microsoft.com> wrote:
>
> >
> >On your subtotaled page, summarize to the level that you want to copy (by
> >clicking on the numbers on the upper left).
> >
> >Select all of the rows. Then select Edit - Go to, hit the "Special
Button"
> >and then "Visable Cells Only".
> >
> >You now can go to where you want to paste, and do paste special, values.
> >
> >
> >
> >"Robin Funnell" wrote:
> >
> >> How do I copy just the subtotal information to a new worksheet?
>