Return multiple values

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
You can write an Event procedure (A WorkSheet_Change Event)which uses the
target cell as a Filter for the range of cells.
 
Back
Top