You can do this with advanced filter.

See Debra Dalgleish's pages which have information on using the advanced
filter.
http://www.contextures.com/tiptech.html

If you want to go right to writing code you can look at Ron de Bruin's page:
http://www.rondebruin.nl/copy5.htm

--
Regards,
Tom Ogilvy



"Amanda" wrote in message
...
I have a spreadsheet with company names and contact (client) information,
owner information, director information, etc. The same client name may
appear more than once within a record or within multiple records. I would
like to be able to enter the client's last name on a separate worksheet
and
have that a list of all of the companies that name is associated with
populate the list. I have tried and tried to figure out how to do this,
but
I just don't understand. Could anyone help me out with this? Thank you
in
advance for any time spent helping me.

Thank you
--
Amanda