You can do this with an Advanced Filter, manually or programmatically.
There are examples he

http://www.contextures.com/excelfiles.html

Under 'Filters', look for "FL0002 - Product List by Week Number" and
"FL0005 - Phone List for Selected Name"

Stephen Hancock wrote:
I have Worksheet 2 with a lot of data. I need to have an input cell on WS1
where I can input serch criteria ("text") as needed and it will then show the
results on WS1.

Any help would be appreciated!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html