Copy Subtotals to another worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When using excel sub total function. How do I copy the sub total to another
worksheet?
 
Hi
Reduce the grouping to show just the information you want. Hit F5 and select
Visible Cells.
Ctrl+C to copy. Move to where you want the totals and click Edit / Paste
Special / Values.
 
You must log in or register to reply here.

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

Getting Text data using the Data - Subtotal feature 1
SUBTOTAL function 3
Skip Copying a protected cell with subtotal 2
Paste Special Values 2
Subtotals 1
Sorting Subtotals 11
EXCEL COPY SUBTOTALS TO ANOTHER WORKSHEETWITHOUT INCLUDING DETAIL 1
Copy within a subtotal 1

Back
Top