Hi There
This is what I want - is this possible ?
I have few cells which has a drop down list eg. apple, banana, grape, carrot
Is there any way for the words to auto fill based on the defined list when the first two or three charcters are typed
eg if I type " Ap " the cell will prompt me "apple"
This occurs now in a normal excel sheet column provided the same name was entered above it and there are no spaces between rows.
Is it possible to have this feature when the only source of information for the cell is the drop down menu
I presume I made my point clear - let me know if you want me to explain with an example
Thanks
cross posted at
http://www.mrexcel.com/forum/showthr...14#post2103414
Bookmarks