Home |
Search |
Today's Posts |
#1
|
|||
|
|||
subtotal
I have subtotal a few hundred rows of data. Is that a way just to copy/transfer the subtotal rows to a new worksheet?
|
#2
|
|||
|
|||
subtotal
I usually make a copy of the entire worksheet (right-click, select Move or
Copy, check the 'copy' box). On the copied sheet, select all the cells and copy / paste special values. Then use the autofilter to select blanks in one of the columns that doesn't have subtotals AND wasn't one of the criteria for the subtotals (OR select rows that end in 'TOTAL' in the criteria column). The remaining rows are the raw data; select and delete. --Bruce "bbking" wrote: I have subtotal a few hundred rows of data. Is that a way just to copy/transfer the subtotal rows to a new worksheet? -- bbking |
#3
|
|||
|
|||
subtotal
Hide the data so that only the subtotals are shown. Select the
subtotals you want to copy. Then choose EDIT; GOTO, SPECIAL. Choose the "Visible Cells Only" radio button and click "ok". Paste this into the desired location. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtotal a range of cells on a different worksheet | Excel Worksheet Functions | |||
Subtotal vs Pivot table - or best way | Excel Discussion (Misc queries) | |||
subtotal - pivot table - or better function | Excel Worksheet Functions | |||
Subtotal Bug in Excel 2003 | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |