| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Working with sub-totaled data
How can I work with sub-totaled data without all of the detail. If I do a
sub-total on column 6, collapse the data then sum the column, all of the detail is used in the calculation. If I try to copy it to a new sheet, or workbook all of the detail comes along. The only way I've been able to work around this is to copy the sub-totaled data to Word and then copy it back to Excel. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I import formmail data to a custom excel template? | Excel Worksheet Functions | |||
| Data Connection wizard quits working | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Threaded Mode
