Write subtotals to another sheet

  • Thread starter Thread starter Gerrym
  • Start date Start date
G

Gerrym

when I apply subtotals to data in a sheet can i write the
results from level 2 to another sheet ?

TKS
 
Show the levels you want to copy (hide the other details).

Create a new worksheet

Back to the subtotal worksheet
Select that range
edit|goto|special
check visible cells only
copy that selection of visible cells.

Paste into that new worksheet.
 
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

To copy subtotal into another sheet 3
subtotal copy and paste 3
Getting Text data using the Data - Subtotal feature 1
Data Subtotals Working Incorrecly 0
subtotal titles 1
Conditional SUBTOTAL in XL210 Table 7
SUBTOTAL 2 WORKSHEETS 6
Copying only subtotals 1

Back
Top