Copy-Paste Subtotals in Filtered Lists

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Howard - 06 Oct 2004 11:40 GMT

Is it possible to paste just the subtotals from a filtered list. I hav
tried to copy and paste the second level in outline view but when
paste I get the whole list rather than just the subtotals

Reply to this Message

Frank Kabel - 06 Oct 2004 12:07 GMT

Hi
after selection your data range try:
- hit F5 and click 'Special'
- choose 'Visible cells only'
- now copy and paste your data

Signature

Regards
Frank Kabel
Frankfurt, Germany

> Is it possible to paste just the subtotals from a filtered list. I
> have tried to copy and paste the second level in outline view but
> when I paste I get the whole list rather than just the subtotals.

Reply to this Message

JulieD - 06 Oct 2004 12:08 GMT

Hi Howard

yes, - collapse it down to level 2 just like you did & select the range that
you want to copy & paste then
choose edit / go to & click on the special button
choose visible cells only
click Ok

now copy & paste as normal.
Let us know how you go

Cheers
JulieD

> Is it possible to paste just the subtotals from a filtered list. I have
> tried to copy and paste the second level in outline view but when I
> paste I get the whole list rather than just the subtotals.

Reply to this Message