| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy & Paste with Subtotals
I have a list on which I have used the subtotal command on the Data menu. I
have then used the outlining buttons on the left to show the detail (rows) that I want. I would like to copy & paste (value only) these so a separte sheet but when I do I find I have copied all the hidden rows as well. Is there any way to do what I want without resorting to VBA? Apologies if I have missed the blindingly obvious. Many thanks, Peter. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy & Paste with Subtotals
Hide your details
select the range to copy edit|Goto|special|Visible cells only edit|copy off to the other sheet edit|paste Peter wrote: I have a list on which I have used the subtotal command on the Data menu. I have then used the outlining buttons on the left to show the detail (rows) that I want. I would like to copy & paste (value only) these so a separte sheet but when I do I find I have copied all the hidden rows as well. Is there any way to do what I want without resorting to VBA? Apologies if I have missed the blindingly obvious. Many thanks, Peter. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy & Paste with Subtotals
Dave,
Magic - worked perfectly. Thanks for the very quick reply much appreciated. Peter "Dave Peterson" wrote: Hide your details select the range to copy edit|Goto|special|Visible cells only edit|copy off to the other sheet edit|paste Peter wrote: I have a list on which I have used the subtotal command on the Data menu. I have then used the outlining buttons on the left to show the detail (rows) that I want. I would like to copy & paste (value only) these so a separte sheet but when I do I find I have copied all the hidden rows as well. Is there any way to do what I want without resorting to VBA? Apologies if I have missed the blindingly obvious. Many thanks, Peter. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Copy and Paste Several Columns of Data into Excel... ? | Excel Discussion (Misc queries) | |||
| Copy and Paste Subtotals only. | Excel Discussion (Misc queries) | |||
| Issue with copy & paste? | Excel Discussion (Misc queries) | |||
| How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
| Copy & Paste | Excel Discussion (Misc queries) | |||
Linear Mode
