Extracting subtotals

[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?

 

[Daryl S]

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.

 

[Dave Peterson]

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.