copy the result of a subtotal

A

Angela

I need to copy the result of a subtotal in a sheet without the data. I
cannot find the function Copy visible cells only.

Lost....
 
R

Ron de Bruin

Hi Angela

If you have used Data>Subtotals then click on 2 to show only the Subtotals

1) Be sure that the active cell is in the data range
2) Press Ctrl * to select all data or use F5>Special>Current region>OK
3) Press Alt ; to select all visible data or use F5>Special>Visible cells only>OK
4) Ctrl c or Edit>Copy
5) Insert>Worksheet
6) Ctrl v or Edit>Paste
7) Select the sheet with the Subtotals
8) Press Esc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine Sumifs with Subtotal 0
Macro Pause to Select range then Subtotal 0
Getting Text data using the Data - Subtotal feature 1
Subtotal 5
Visio Diagram Protection 0
subtotal copy and paste 3
Vlookup a subtotal 2
I need ONLY subtotals copied to a second sheet 4

Top