| 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. |
| 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) | |||
Threaded Mode
