Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compressed Outlined Data Copy
I need to copy only the data that is compressed in Grouped rows and not all
the rows when they are expanded. When I copy and paste the compressed data, I get all the data that is within the group, and not just the compressed data. For example: I need just the following (which is compressed): Ship $ Line $5,278.00 CYP Total $133,122.00 TI Total $34,660,135.00 Vic Total $34,798,535.00 Grand Total when I copy it (D2:E17, but only showing 5 lines because of the compression), it pastes 16 lines: Ship $ Line $123.00 CYP $44.00 CYP $4,444.00 CYP $667.00 CYP $5,278.00 CYP Total $123,124.00 TI $444.00 TI $666.00 TI $8,888.00 TI $133,122.00 TI Total $34,653,465.00 Vic $4.00 Vic $6,666.00 Vic $34,660,135.00 Vic Total $34,798,535.00 Grand Total Is there a way to do this? Thanks, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
using programming to copy worksheets data only | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | New Users to Excel | |||
How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) |