HI ALL
i record a macro for advance filter but i have problem of exact match i have items blue , blue3 , blue 45 ect when i filter its filter all blue i want only blue when i filter blue can some body help me to correct vba code to 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
Bookmarks