Excel 2002: Advance filter - copying to another page

[Mr. Low]

Hi,

I try to use advance filter to select data by copying it to another page in
the same file, however the system tells me that I can do it on the active
page only. Is this truely the limitation of Excel 2002 ? How about the later
versions ?

Thanks

Low

 

[Jacob Skaria]

Dear, it is the same with the latest version (2007)

 

[Ron de Bruin]

How do you copy, with code ?

 

[Mr. Low]

Hi Ron,

By selecting copying to another location at the Advance Filter menu. After
this I put the cursor at the 3rd parameter of Advance filter and move the
cursor to a cell in the next page to get the cell address automatically. For
criteria (2nd parameter) I highlight the headings and descriptions at the
criteria table. After this I click ok.

Thanks

Low

 

[Ron de Bruin]

You can create a macro to do the copy of your visible data to a new sheet after you filter in place.
Is that a option ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

Hi Ron,

By selecting copying to another location at the Advance Filter menu. After
this I put the cursor at the 3rd parameter of Advance filter and move the
cursor to a cell in the next page to get the cell address automatically. For
criteria (2nd parameter) I highlight the headings and descriptions at the
criteria table. After this I click ok.

Thanks

Low

 

[Mr. Low]

Hi Ron,

I just want to know if this is realy the limitation of Excel 2002 Advance
Filter.

I do not need a macro as I am not familiar with executing Macros.

There are many other ways that I am familiar with for of doing this job. the
only things is that it takes a longer time.

Thanks anyway for your reply.

Low

 

[Ron de Bruin]

See
http://www.contextures.com/xladvfilter01.html#ExtractWs

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

Hi Ron,

I just want to know if this is realy the limitation of Excel 2002 Advance
Filter.

I do not need a macro as I am not familiar with executing Macros.

There are many other ways that I am familiar with for of doing this job. the
only things is that it takes a longer time.

Thanks anyway for your reply.

Low

 

[Gord Dibben]

It is not a limitation of Excel 2002 or any other version.

You just have to start your operation from the destination sheet rather than
from the source sheet.


Gord Dibben MS Excel MVP

 

[Mr. Low]

Hi Gord,

Thanks for your advise.

Low