| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I copy subtotals to another sheet?
When I collapse into level 2, I need to copy just the totals into another
sheet. Does anyone know how to do this w/o getting all of the intervening rows? Thanks..........Alisa |
|
#2
|
|||
|
|||
|
Hi
- select your data range - hit F5, click 'Special' and choose 'Visible cells only' - now copy+paste -- Regards Frank Kabel Frankfurt, Germany "Alisa" schrieb im Newsbeitrag ... When I collapse into level 2, I need to copy just the totals into another sheet. Does anyone know how to do this w/o getting all of the intervening rows? Thanks..........Alisa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
| vba to sort group copy paste to another sheet | Excel Worksheet Functions | |||
Linear Mode
