Prev: Shared book (sorry!) bloating and not disconnecting
Next: autoformat add or change
From: Maki on 12 Jan 2010 09:40
Hi

Whenever I do Advanced Filter >Copy to another location, Excel wouldn't
allow me to specify the destination (i.e. Copy to:) on worksheet other than
the one I'm currently working on.

Isn't there a way around this?

--
Maki @ Canberra.AU
From: Gord Dibben on 12 Jan 2010 17:50
Yes, there is a way around this.

You must start the operation from the sheet you want to be the destination
sheet.

See Debra Dalgleish's site for how-to with a video should you choose.

http://www.contextures.on.ca/xladvfilter01.html#ExtractWs


Gord Dibben MS Excel MVP

On Tue, 12 Jan 2010 06:40:01 -0800, Maki <Maki(a)discussions.microsoft.com>
wrote:

>Hi
>
>Whenever I do Advanced Filter >Copy to another location, Excel wouldn't
>allow me to specify the destination (i.e. Copy to:) on worksheet other than
>the one I'm currently working on.
>
>Isn't there a way around this?

 | 
Pages: 1
Prev: Shared book (sorry!) bloating and not disconnecting
Next: autoformat add or change