auto filter automatically based on two cell values

  • i am using a sheet event code to autofilter a range based on a cell value with support for regular expression


    this code will filter column c
    based on criteria in cell n1
    can this code be edited so that it will filter column d also based on cell value "o1"

  • Re: auto filter automatically based on two cell values


    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

  • Re: auto filter automatically based on two cell values


    thanks it working perfect
    i am always using the criteria inside * like (*criteria*)
    is this possible to avoid putting * around criteria in o1 and n1
    i want code treat the criteria beginning and end as * so that it will always filter as -"criteria containing" and not as exact criteria

  • Re: auto filter automatically based on two cell values


    Try this

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

Participate now!

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