Use DataFilterAdvanced filter

As Criteria range enter Country as column header in A1, enter USA in A2
Criteria range: $A$1:$A$2

HTH
--
AP

"SKY" a écrit dans le message de
...
I would like to extract matched data from one worksheet and put into
another.
For example, a table contains two columns, country and city,
Country City
CN SZ
CN BJ
USA SEA
USA SFO

On a blank worksheet, enter "USA" in A1, how can I copy only the last two
rows?
I try INDEX & MATCH functions, it always finds the first row. How can I
tell
the Excel to make a on-going MATCH until it finish an array?