| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Write subtotals to another sheet
when I apply subtotals to data in a sheet can i write the
results from level 2 to another sheet ? TKS |
|
#2
|
|||
|
|||
|
Show the levels you want to copy (hide the other details).
Create a new worksheet Back to the subtotal worksheet Select that range edit|goto|special check visible cells only copy that selection of visible cells. Paste into that new worksheet. Gerrym wrote: when I apply subtotals to data in a sheet can i write the results from level 2 to another sheet ? TKS -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to write to other sheet if and only if? | Excel Worksheet Functions | |||
| PASTE SUBTOTALS IN EXCEL TO ANOTHER SHEET TO DO ANOTHER SORT | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| How do I copy subtotals to another sheet? | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Linear Mode
