Return multiple values

[Guest]

I have a spreadsheet that has three columns, last name, first name,
and user ID. I would like user to be able to enter in a cell part of
a last name i.e. Col and have excel show all partial matches for user
name (coletl, coled, colesn etc). I would prefer that the user only
see the results not the whole list.

Any suggestions?

 

[Bob Umlas]

You can write an Event procedure (A WorkSheet_Change Event)which uses the
target cell as a Filter for the range of cells.