| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i copy only the subtotals inserted into a list?
I have a list that I have inserted subtotals into, with Data, Subtotals. For
instance, a count function that counts the items in a list when the data in the first column changes. Then i only want to copy the subtotal data, only the counts of the first column items. I only need the subtotals (counts) not the detail list. How do i do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i copy only the subtotals inserted into a list?
Use the outlining symbols to the left to hide the stuff you don't want.
Select the range to copy edit|goto|special select visible cells edit|copy And then select the destination cell and edit|paste. scross88 wrote: I have a list that I have inserted subtotals into, with Data, Subtotals. For instance, a count function that counts the items in a list when the data in the first column changes. Then i only want to copy the subtotal data, only the counts of the first column items. I only need the subtotals (counts) not the detail list. How do i do this? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i copy only the subtotals inserted into a list?
Thanks! .. it is always the little things ..this has been bugging me for some
time, and no one in my office could answer it! .. made my week! "Dave Peterson" wrote: Use the outlining symbols to the left to hide the stuff you don't want. Select the range to copy edit|goto|special select visible cells edit|copy And then select the destination cell and edit|paste. scross88 wrote: I have a list that I have inserted subtotals into, with Data, Subtotals. For instance, a count function that counts the items in a list when the data in the first column changes. Then i only want to copy the subtotal data, only the counts of the first column items. I only need the subtotals (counts) not the detail list. How do i do this? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and Paste Subtotals only. | Excel Discussion (Misc queries) | |||
| List box, copy multiple Cells | Excel Worksheet Functions | |||
| How to copy data validation utilizing a list to the entire column | Excel Worksheet Functions | |||
| Copy Subtotals to another worksheet | Excel Discussion (Misc queries) | |||
| How do I copy Summary totals only from a subtotal list? | Excel Discussion (Misc queries) | |||
Linear Mode
