Advanced Filter question

[udigold1]

I've created a list with codes, for example:
Stocks in US, code 1_1
Stocks in Europe, code 1_12
Stocks in Asia, code 1_13

I'm using the advanced filter, so I coulde see detailed information for each category, but when I try to filter "Stocks in US" I get details for all the categories even though I use criteria. How can I get details for code 1_1 only?
the code is like this :

Sheets("PirutData" & s).Activate
 Sheets("data" & s).Range(Range("extract" & s), _ 
Range("extract" & s).End(xlToRight).End(xlDown)).AdvancedFilter _
 Action:=xlFilterCopy, CriteriaRange:=Range("critpirut" & s), _ 
CopyToRange:=Range("outputpirut" & s), Unique:=False

thanks,
Udi

 

[Wolfshead]

Hi
In your criteria type: ="=1_1"
If you don't there is an implied asterisk after whatever you type. Therefore 1_1 in criteria cell includes 1_12 etc

Hope this helps
Wolfshead