Advance Filter To Another Worksheet

  • Here is the code i am using:

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

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> 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!