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.
 
Back
Top