Advance Filter To Another Worksheet

  • Here is the code i am using:

    Range("A:I").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
            "O14:O15"), CopyToRange:=Worksheets("Report2).Range("A19"), Unique:=False

    I am basically trying to advance filter data on worksheet "Custpercust" and i want to filter it to another worksheet, which is "Report2".

  • Re: Advance Filter To Another Worksheet

    That's impossible.

    You need to copy / cut the filtered rows to the other sheet.



    Excel MVP 2011-2014

    For more Excel memes: visit ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!