SubTotals

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hello,
After adding subtotals to a table and collapsing the table to view the
totals, is there a way to copy the totals only to a new worksheet? When I
select the rows, I end up copying everything to the new worksheet.

Thanks.

Bill
 
Hi after collapsing and selecting the range try:
- hit F5 and click 'Special'
- choose 'Only visible cells'
- copy and paste the range
 
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
Copy subtotals 1
Pivot Table Subtotals 1
Copying subtotals 2
Conditional SUBTOTAL in XL210 Table 7
subtotal 1
Presenting Subtotals only 2
Copying from Subtotal Data 2

Back
Top