AdvancedFilter VBA extracts not exact data

[Sahak]

Hi All,

I have database where one Colum is for Stores Like

Stores
Home Depot
Home Depot First
Home Depot Second
Ralphs
Food 4 Less
. . . . . . .

By Macro Im trying to extract data for store “Home Depot” only. In Criteria range I have:

Stores
Home Depot

Sub Filter_Stores()
    Range("Stores_DB").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range _
            ("Criteria_Stores"), CopyToRange:=Range("CopyHere_StoresRng"), Unique:=False
End Sub

After running macro, it extracts data for all three stores (Home Depot, Home Depot First, Home Depot Second)
which starts with “Home Depot”

Any idea ?

Thank you in advance

 

[Peter_SSs]

It depends a bit on how you are populating "Home Depot" into the range "Criteria_Stores" but the essence is that you need the text "=Home Depot" in that cell, not just "Home Depot"

 

[Sahak]

Thank you Peter VERY much, you are genius.