Copying Subtotals?

[Guest]

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

 

[Guest]

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.

 

[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

 

[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