Hi,

My posting today refers.

If it is the case that the user could not perform this function in all
version of Excel , I would suggest that MS to enable this function in the
future version.

This would enmable users to work better and faster with large data tables.

Hope tbat my7 feedback helps.

Low
===============================================
Dear, it is the same with the latest version (2007)
--
If this post helps click Yes
---------------
Jacob Skaria


"Mr. Low" wrote:

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


--
A36B58K641

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

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


--

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




"Mr. Low" wrote in message ...
Hi,

My posting today refers.

If it is the case that the user could not perform this function in all
version of Excel , I would suggest that MS to enable this function in the
future version.

This would enmable users to work better and faster with large data tables.

Hope tbat my7 feedback helps.

Low
===============================================
Dear, it is the same with the latest version (2007)
--
If this post helps click Yes
---------------
Jacob Skaria


"Mr. Low" wrote:

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


--
A36B58K641

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Hi Ron,

Thanks for the info.

Low
--
A36B58K641


"Ron de Bruin" wrote:

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


--

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




"Mr. Low" wrote in message ...
Hi,

My posting today refers.

If it is the case that the user could not perform this function in all
version of Excel , I would suggest that MS to enable this function in the
future version.

This would enmable users to work better and faster with large data tables.

Hope tbat my7 feedback helps.

Low
===============================================
Dear, it is the same with the latest version (2007)
--
If this post helps click Yes
---------------
Jacob Skaria


"Mr. Low" wrote:

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


--
A36B58K641

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc