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

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

Then you can Copy/Paste SpecialValues only the visible cells.

Does that help?

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

XL2002, WinXP-Pro


"mvyvoda" wrote:

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

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

Thanks so much,
Mark

"Ron Coderre" wrote:

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

Then you can Copy/Paste SpecialValues only the visible cells.

Does that help?

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

XL2002, WinXP-Pro


"mvyvoda" wrote:

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

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

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

XL2002, WinXP-Pro


"mvyvoda" wrote:

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

Thanks so much,
Mark

"Ron Coderre" wrote:

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

Then you can Copy/Paste SpecialValues only the visible cells.

Does that help?

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

XL2002, WinXP-Pro


"mvyvoda" wrote:

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