Hi Robert

You could just use a filter.
If you are using XL2003, place cursor within data
listDataListCreateclick my list has headers

If you are using XL2007, place cursor within data listInsert
tabTableclick my table has headers

In both cases a dynamic List/Table will be created, which will grow as you
add more items.
Using the dropdown on each column header you can select individual values,
or begins with, or contains and many other options.

If you don't want to use the dropdowns, I have created a file called
FastFilter, which just allows you to type your search criteria directly into
the row above your filter.
It can be downloaded from
http://www.contextures.com/Fastfilter.zip
--
-------
Regards
Roger Govier

"Robert Crandal" wrote in message
...
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



__________ Information from ESET Smart Security, version of virus
signature database 4893 (20100224) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4893 (20100224) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4901 (20100227) __________

The message was checked by ESET Smart Security.

http://www.eset.com