Extracting subtotals

  • Thread starter Thread starter No Accounting For IT
  • Start date Start date
N

No Accounting For IT

I have a worksheet (Excel2007) that shows accounts sales data. The table has
sub-totals showing the sum of the sales from each account.

I need to transfer the data to another sheet to create a table that contains
just the rows with sub-total values, and without the rest of the data (so
that I can import the sub-total figures into another piece of software).

Anyone know how to do this?
 
Excel has a great feature called Visible Cells Only.

With just the subtotals showing, go to Edit | Go To | Special | Visible
Cells Only

Then Copy (Ctrl C)

Then go to the other sheet and paste.
 
Hide the details to show just the subtotals
Select the entire range to copy
hit F5|Special|visible cells only
Copy those visible rows

and paste to your other location.
 

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

Extracting data from Multiple columns to a Single row 1
Create a yes no message on a command button on click 0
Average of Subtotals in Pivot Table 0
correlating and summing data from multiple spreadsheets 1
Macro for Sub totaling multiple sheets 4
I need ONLY subtotals copied to a second sheet 4
SumProduct in "for each" loop 3
Getting Text data using the Data - Subtotal feature 1

Back
Top