Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy sub total data only onto a new worksheet?
When subtotaling a large amount of data I would like to be able to copy and
paste just the subtotal-ed information. When I try to do this I cant figure out how to eliminate the underlying data from copying too. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy sub total data only onto a new worksheet?
Hi,
Select your data and press F5, Special, Visible cells only, OK. Then copy. If this helps, please click the yes button Cheers, Shane Devenshire "khuff" wrote: When subtotaling a large amount of data I would like to be able to copy and paste just the subtotal-ed information. When I try to do this I cant figure out how to eliminate the underlying data from copying too. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy sub total data only onto a new worksheet?
Thanks Shane,
That F5 key seems to be helpful to know. Is there another way to get to that tool other than using the F5 key? "Shane Devenshire" wrote: Hi, Select your data and press F5, Special, Visible cells only, OK. Then copy. If this helps, please click the yes button Cheers, Shane Devenshire "khuff" wrote: When subtotaling a large amount of data I would like to be able to copy and paste just the subtotal-ed information. When I try to do this I cant figure out how to eliminate the underlying data from copying too. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy data from one worksheet to another | Excel Worksheet Functions | |||
How to get month wise total of a worksheet having a years data? | Excel Discussion (Misc queries) | |||
copy from B worksheet to A worksheet with NO repeated data | Excel Discussion (Misc queries) | |||
copy data in a cell from worksheet A to worksheet B | Excel Discussion (Misc queries) | |||
PLEASE HELP......COPY DATA FROM ONE WORKSHEET TO ANOTHER | Excel Worksheet Functions |