advance filter exact match

hi all
i record a macro for advance filter for items lists i have items like blue , blue ex, blue 3 but when i want to filter blue its filter blue and blue 3 and blue ex i only want the filter of blue how to correct vba code for exact match, THANKS

Sub ITEM_LEDGER()
'
' ITEM_LEDGER Macro
'

'
Sheets("MASTER_SHEET").Range("Table1[#All]").AdvancedFilter Action:= _
xlFilterCopy, CriteriaRange:=Range("F1:F2"), CopyToRange:=Range("E4:V4"), _
Unique:=False
End Sub

Thanks for ur reply

msg showing no matches

Note that the filter is placed on the first column of the table, yoi should probably change that

ok thnaks i will try it

Alternative with inputbox. Using the filter method for exact matches

Please Login or Register  to view this content.