Copying Subtotals?
 

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

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 wrote in message
...
How do I copy just the subtotal information to a new worksheet?

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?

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"
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?

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" wrote in message
...
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"
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?