Using copy/paste after subtotalling

[Heidi]

I often use the Data > Subtotals... feature. Then I can click the different
outline levels to view just the calculated subtotalled values (no raw data).
However, when I want to copy just the subtotalled data into a new sheet, I
can't just select the subtotalled cells as a group, because the hidden rows
of raw data come with it as well.

Is there an easy way to select just the rows that have subtotals in them?

Thank you,

Heidi

[vezerid]

Heidi,

Select your subtotals and then Edit|Go To... Click on Special button.
In the following screen select Visible Cells only. Then Copy.

Also, for similar tasks you can use a Pivot Table. In this case you
don't have to bother selecting only visible cells, because the Pivot
Table will reside on a separate range.

HTH
Kostis Vezerides

[Heidi]

Thanks! That looks like just the feature I need. Unfortunately, it seems to
crash my computer every time I try to "paste" afterwards, but that is
probably an issue with our weird network installation. I'll see if the
PivotTable route is a little more stable.

Thanks again!

Heidi

"vezerid" wrote:

> Heidi,
>
> Select your subtotals and then Edit|Go To... Click on Special button.
> In the following screen select Visible Cells only. Then Copy.
>
> Also, for similar tasks you can use a Pivot Table. In this case you
> don't have to bother selecting only visible cells, because the Pivot
> Table will reside on a separate range.
>
> HTH
> Kostis Vezerides
>
>

[Marc]

Also, I'd suggest doing a "paste special" as "value" to be sure you aren't
copying formulas.

And I defnitely agree that pivot tables are the way to go--you don't have to
worry about sorting the data first like you do with subtotalling... they are
much more flexible.

"Heidi" <Heidi@discussions.microsoft.com> wrote in message
news:A999B3B3-500F-494B-A83D-A0CBC88DEB8C@microsoft.com...
> I often use the Data > Subtotals... feature. Then I can click the
different
> outline levels to view just the calculated subtotalled values (no raw
data).
> However, when I want to copy just the subtotalled data into a new sheet, I
> can't just select the subtotalled cells as a group, because the hidden
rows
> of raw data come with it as well.
>
> Is there an easy way to select just the rows that have subtotals in them?
>
> Thank you,
>
> Heidi