I'd use the built-in data|filter|autofilter.

Robert Crandal wrote:

My spreadsheet contains about 100 to 200 rows of data.
We will also add more rows of data over time. If I wanted
to add a search feature which would display a subset of
rows that match a specific criteria, what is a good way to
do this??

Should I just create a loop that steps through each row
and picks out all the matches and displays them on
a userform or something??? Are there other ways???

thank you

--

Dave Peterson