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

On Wed, 27 May 2009 09:15:02 -0700, Mr. Low
wrote:

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