search a list while typing in a cell
Is there anyway to make a cell in excel to act like a search box?
For example you have a name list in a separate sheet or column. While typing on a cell, a macro or formula would automatically search for a match on the name list... (and make popping suggestions of data to enter when a match is found in the list. Is there any such feature ?) Thank you.
|