software

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.00CYP Total
$133,122.00TI Total
$34,660,135.00Vic Total
$34,798,535.00Grand Total

when I copy it (D2:E17, but only showing 5 lines because of the
compression), it pastes 16 lines:

Ship $Line
$123.00CYP
$44.00CYP
$4,444.00CYP
$667.00CYP
$5,278.00CYP Total
$123,124.00TI
$444.00TI
$666.00TI
$8,888.00TI
$133,122.00TI Total
$34,653,465.00Vic
$4.00Vic
$6,666.00Vic
$34,660,135.00Vic Total
$34,798,535.00Grand Total

Is there a way to do this?

Thanks,
Mark

Try this:
After selecting the range you want....
Editgt;Goto
click the [Special Cells] button
Select: Visible Cells only
Click the [OK] button

Then you can Copy/Paste Specialgt;Values only the visible cells.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;mvyvodaquot; wrote:

gt; I need to copy only the data that is compressed in Grouped rows and not all
gt; the rows when they are expanded.
gt;
gt; When I copy and paste the compressed data, I get all the data that is within
gt; the group, and not just the compressed data. For example:
gt;
gt; I need just the following (which is compressed):
gt; Ship $Line
gt; $5,278.00CYP Total
gt; $133,122.00TI Total
gt; $34,660,135.00Vic Total
gt; $34,798,535.00Grand Total
gt;
gt; when I copy it (D2:E17, but only showing 5 lines because of the
gt; compression), it pastes 16 lines:
gt;
gt; Ship $Line
gt; $123.00CYP
gt; $44.00CYP
gt; $4,444.00CYP
gt; $667.00CYP
gt; $5,278.00CYP Total
gt; $123,124.00TI
gt; $444.00TI
gt; $666.00TI
gt; $8,888.00TI
gt; $133,122.00TI Total
gt; $34,653,465.00Vic
gt; $4.00Vic
gt; $6,666.00Vic
gt; $34,660,135.00Vic Total
gt; $34,798,535.00Grand Total
gt;
gt; Is there a way to do this?
gt;
gt; Thanks,
gt; Mark

Ron Coderre, you're my hero. I actually tried that a while ago, but I must
have done something wrong.

Thanks so much,
Mark

quot;Ron Coderrequot; wrote:

gt; Try this:
gt; After selecting the range you want....
gt; Editgt;Goto
gt; click the [Special Cells] button
gt; Select: Visible Cells only
gt; Click the [OK] button
gt;
gt; Then you can Copy/Paste Specialgt;Values only the visible cells.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;mvyvodaquot; wrote:
gt;
gt; gt; I need to copy only the data that is compressed in Grouped rows and not all
gt; gt; the rows when they are expanded.
gt; gt;
gt; gt; When I copy and paste the compressed data, I get all the data that is within
gt; gt; the group, and not just the compressed data. For example:
gt; gt;
gt; gt; I need just the following (which is compressed):
gt; gt; Ship $Line
gt; gt; $5,278.00CYP Total
gt; gt; $133,122.00TI Total
gt; gt; $34,660,135.00Vic Total
gt; gt; $34,798,535.00Grand Total
gt; gt;
gt; gt; when I copy it (D2:E17, but only showing 5 lines because of the
gt; gt; compression), it pastes 16 lines:
gt; gt;
gt; gt; Ship $Line
gt; gt; $123.00CYP
gt; gt; $44.00CYP
gt; gt; $4,444.00CYP
gt; gt; $667.00CYP
gt; gt; $5,278.00CYP Total
gt; gt; $123,124.00TI
gt; gt; $444.00TI
gt; gt; $666.00TI
gt; gt; $8,888.00TI
gt; gt; $133,122.00TI Total
gt; gt; $34,653,465.00Vic
gt; gt; $4.00Vic
gt; gt; $6,666.00Vic
gt; gt; $34,660,135.00Vic Total
gt; gt; $34,798,535.00Grand Total
gt; gt;
gt; gt; Is there a way to do this?
gt; gt;
gt; gt; Thanks,
gt; gt; Mark

Thanks for the feedback....I'm glad that worked for you.

***********
Regards,
Ron

XL2002, WinXP-Proquot;mvyvodaquot; wrote:

gt; Ron Coderre, you're my hero. I actually tried that a while ago, but I must
gt; have done something wrong.
gt;
gt; Thanks so much,
gt; Mark
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; Try this:
gt; gt; After selecting the range you want....
gt; gt; Editgt;Goto
gt; gt; click the [Special Cells] button
gt; gt; Select: Visible Cells only
gt; gt; Click the [OK] button
gt; gt;
gt; gt; Then you can Copy/Paste Specialgt;Values only the visible cells.
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;mvyvodaquot; wrote:
gt; gt;
gt; gt; gt; I need to copy only the data that is compressed in Grouped rows and not all
gt; gt; gt; the rows when they are expanded.
gt; gt; gt;
gt; gt; gt; When I copy and paste the compressed data, I get all the data that is within
gt; gt; gt; the group, and not just the compressed data. For example:
gt; gt; gt;
gt; gt; gt; I need just the following (which is compressed):
gt; gt; gt; Ship $Line
gt; gt; gt; $5,278.00CYP Total
gt; gt; gt; $133,122.00TI Total
gt; gt; gt; $34,660,135.00Vic Total
gt; gt; gt; $34,798,535.00Grand Total
gt; gt; gt;
gt; gt; gt; when I copy it (D2:E17, but only showing 5 lines because of the
gt; gt; gt; compression), it pastes 16 lines:
gt; gt; gt;
gt; gt; gt; Ship $Line
gt; gt; gt; $123.00CYP
gt; gt; gt; $44.00CYP
gt; gt; gt; $4,444.00CYP
gt; gt; gt; $667.00CYP
gt; gt; gt; $5,278.00CYP Total
gt; gt; gt; $123,124.00TI
gt; gt; gt; $444.00TI
gt; gt; gt; $666.00TI
gt; gt; gt; $8,888.00TI
gt; gt; gt; $133,122.00TI Total
gt; gt; gt; $34,653,465.00Vic
gt; gt; gt; $4.00Vic
gt; gt; gt; $6,666.00Vic
gt; gt; gt; $34,660,135.00Vic Total
gt; gt; gt; $34,798,535.00Grand Total
gt; gt; gt;
gt; gt; gt; Is there a way to do this?
gt; gt; gt;
gt; gt; gt; Thanks,
gt; gt; gt; Mark