Hello:

I have an Excel displays subtotals based on the average of other fields.

I click the "2", in order to collapse the rows to just show the "Average"
and not the detail.

I simply want to copy into another spreadsheet these "Average" rows. But,
when I paste, it pastes the detail--not the "summarized" row averages.

Is there not a way of copying and pasting the summarized data?

childofthe1980s

What happens if you CopyPasteSpecialValues?childofthe1980s;456511 Wrote:
Hello:

I have an Excel displays subtotals based on the average of other
fields.

I click the "2", in order to collapse the rows to just show the
"Average"
and not the detail.

I simply want to copy into another spreadsheet these "Average" rows.
But,
when I paste, it pastes the detail--not the "summarized" row averages.

Is there not a way of copying and pasting the summarized data?

childofthe1980s


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126354

Hi,
once you hit 2, highlight the range you get, then CTRL G, Special, Visible
cells only, copy, then paste it in your desire location

if this helps please click yes

"childofthe1980s" wrote:

Hello:

I have an Excel displays subtotals based on the average of other fields.

I click the "2", in order to collapse the rows to just show the "Average"
and not the detail.

I simply want to copy into another spreadsheet these "Average" rows. But,
when I paste, it pastes the detail--not the "summarized" row averages.

Is there not a way of copying and pasting the summarized data?

childofthe1980s

That worked perfectly, Eduardo! Thank you!

childofthe1980s

"Eduardo" wrote:

Hi,
once you hit 2, highlight the range you get, then CTRL G, Special, Visible
cells only, copy, then paste it in your desire location

if this helps please click yes

"childofthe1980s" wrote:

Hello:

I have an Excel displays subtotals based on the average of other fields.

I click the "2", in order to collapse the rows to just show the "Average"
and not the detail.

I simply want to copy into another spreadsheet these "Average" rows. But,
when I paste, it pastes the detail--not the "summarized" row averages.

Is there not a way of copying and pasting the summarized data?

childofthe1980s

your welcome, thanks for the feedback

"childofthe1980s" wrote:

That worked perfectly, Eduardo! Thank you!

childofthe1980s

"Eduardo" wrote:

Hi,
once you hit 2, highlight the range you get, then CTRL G, Special, Visible
cells only, copy, then paste it in your desire location

if this helps please click yes

"childofthe1980s" wrote:

Hello:

I have an Excel displays subtotals based on the average of other fields.

I click the "2", in order to collapse the rows to just show the "Average"
and not the detail.

I simply want to copy into another spreadsheet these "Average" rows. But,
when I paste, it pastes the detail--not the "summarized" row averages.

Is there not a way of copying and pasting the summarized data?

childofthe1980s