List rows

[tapnawk99]

I have simple excel like
A B C
1 apple $10 USA
2 Orange $20 Africa
3 Apple $5 China

And I want another sheet to insert e.g. "apple" it will returns the
whole rows which match
"apple"


apple $10 USA
Apple $5 China

 

[JE McGimpsey]

One way would be to use Advanced Filter:

http://www.contextures.com/xladvfilter01.html#ExtractWs