VBA code to auto filter using cell reference

[Mayur99]

Hi,

I need a VBA code to autofilter list of values reference from a different sheet. The filter condition is such it should contain the values in the referenced cells not equal to the value in the cell

The code I have been trying is as below

Worksheets("ZBA extract").select
Activesheet.Range("A1:W10000").autofilter Field:=12 Criteria:=Worksheets(Ref Data) "*" & .Range("E4:E9").Value & "*"

 

[Fluff]

Hi & welcome to MrExcel.
You can only use more than 2 criteria when doing an exact match.
Have a look at using Advanced filters instead.

Excel Advanced Filter – how to create and use

The tutorial explains the basics of Excel Advanced Filter and how to use it to find data that meets one or more complex criteria.

www.ablebits.com