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