I am attempting to add a VB filter that is filtering based on the range containing a select number of options.
Example:
Column E -
ActiveSheet.Range("E:E").AutoFilter Field:=5, Criteria1:= _
Array("*" & "HLT_", "CCS_", "LCB_", "ACB_", & "*"), Operator:=xlFilterValues
If the data in E contains any of those criteria it will filter to the remaining out.
Dog
HLT_Dog
HLT_Cat
HTL_Mouse
Mouse
LCB_Mouse
I would only want the results with the prefix.
Any help would be appreciated.
Example:
Column E -
ActiveSheet.Range("E:E").AutoFilter Field:=5, Criteria1:= _
Array("*" & "HLT_", "CCS_", "LCB_", "ACB_", & "*"), Operator:=xlFilterValues
If the data in E contains any of those criteria it will filter to the remaining out.
Dog
HLT_Dog
HLT_Cat
HTL_Mouse
Mouse
LCB_Mouse
I would only want the results with the prefix.
Any help would be appreciated.