Text filter that contains a text

[LeanneBG]

Hi Experts! I know it sounds so simple.. but i cannot seem to find the answers.. I have below code that used to filter the exact "SELECTED_PRCS_PC_FLN", however, i found out that sometimes the data shows not only "SELECTED_PRCS_PC_FLN" but also this :SELECTED_PC_FLN". Is there a way to just change it to filter something that contains "PC_FLN" instead of the specific "SELECTED_PRCS_PC_FLN"? So that it can capture even those that are tagged as "SELECTED_PC_FLN" and others that have "PC_FLN" in its name.. Thanks in advance!

ActiveSheet.Range("$A$1:$L$1000").AutoFilter Field:=6, Criteria1:= _
        "SELECTED_PRCS_PC_FLN"

 

[LeanneBG]

Ok, the REPLACE is acting on columns "F" & "Q", is that correct ?
You are working on the correct sheet ?
Are all the texts in UPPER case ?

Yes, it can be found on column F and Q and it's all in capital letters. Attaching here the macro im using..

https://drive.google.com/file/d/1ItEs8QvUFwwO8Rt7nUxTKJN9m2llGNnq/view?usp=sharing

 

[Michael M]

Ok, try this one

Sub MM1()
Dim lr As Long, n As Long
Sheets("SRPT").Select
lr = Range("A" & Rows.Count).End(xlUp).Row
    With Range("F1:F" & lr)
        .Replace "SELECTED_PC_FLN", "SELECTED_PRCS_PC_FLN"
        .Replace "SELECTED_MONTH_START", "SELECTED_PRCS_MONTH_START"
        .Replace "SELECTED_SCN_TGT", "SELECTED_PRCS_SCN_TGT"
    End With
    With Range("Q1:Q" & lr)
        .Replace "SELECTED_PC_FLN", "SELECTED_PRCS_PC_FLN"
        .Replace "SELECTED_MONTH_START", "SELECTED_PRCS_MONTH_START"
        .Replace "SELECTED_SCN_TGT", "SELECTED_PRCS_SCN_TGT"
    End With
End Sub

 

[LeanneBG]

Ok, try this one

Sub MM1()
Dim lr As Long, n As Long
Sheets("SRPT").Select
lr = Range("A" & Rows.Count).End(xlUp).Row
    With Range("F1:F" & lr)
        .Replace "SELECTED_PC_FLN", "SELECTED_PRCS_PC_FLN"
        .Replace "SELECTED_MONTH_START", "SELECTED_PRCS_MONTH_START"
        .Replace "SELECTED_SCN_TGT", "SELECTED_PRCS_SCN_TGT"
    End With
    With Range("Q1:Q" & lr)
        .Replace "SELECTED_PC_FLN", "SELECTED_PRCS_PC_FLN"
        .Replace "SELECTED_MONTH_START", "SELECTED_PRCS_MONTH_START"
        .Replace "SELECTED_SCN_TGT", "SELECTED_PRCS_SCN_TGT"
    End With
End Sub

Hi @Michael M, I just did some tweaks but it is now working Thank you for all your help. :D

 

[Michael M]

Okay.......thx for the feedback