How do I copy Summary totals only from a subtotal list?

[Guest]

I remember reading there is a way of copying only the summary totals from a
Subtotalled list that has only the summary totals (subtotals) showing. I
cannot remember the method / keystrokes however.

Using CTRL+C or Edit>Copy copies the underlying data also- and I have pages
of that I want to leave behind.

Does anyone know how I do this please? Thanks in anticipation,
Dominic

 

[Guest]

Hi
Try edit goto special visible cells only

 

[Guest]

Hi Dominic-

Try it this way,

Ctrl+Click the cells containing the Subtotals, then Copy & Paste. Make sure
to Ctrl+Click each cell, don't drag because you'll get an error when you try
to Copy.

Hope this is useful |:>)

 

[Guest]

Thank you To Tina & CyberTaz for the responses. Tina's worked perfectly,
thank you very much for your help.

Dominic.