apgmin
Board Regular
- Joined
- Mar 1, 2010
- Messages
- 143
- Office Version
- 2013
- Platform
- Windows
Can anyone please tell me how to do this.
From Cells A1 to A9 I have a list of names
From Cells B1 to B 40 I made a data validation list so that the user can select only the names in Cell A1 to A9
Works fine,
However it will be more user friendly if the cell say B 30 while being data entered, suggests from the drop down list based on the characters input by the user so he will not have to use the cursor to select the name from the drop down list but after seeing the match just press enter to fill the cell
From Cells A1 to A9 I have a list of names
From Cells B1 to B 40 I made a data validation list so that the user can select only the names in Cell A1 to A9
Works fine,
However it will be more user friendly if the cell say B 30 while being data entered, suggests from the drop down list based on the characters input by the user so he will not have to use the cursor to select the name from the drop down list but after seeing the match just press enter to fill the cell