Excel 2002: Advance filter - copying to another page

  • Thread starter Thread starter Mr. Low
  • Start date Start date
M

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
 
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
 
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
 
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




Mr. Low said:
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
Click to expand...
 
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




Mr. Low said:
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
Click to expand...
 
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
 
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
 
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
 
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
 
Back
Top