AutoComplete in cell from list?

[tmarcello935]

I have a long list of MFGs, instead of doing a drop down list, with 3000 names, I am asking if there is a way to autocomplete from the list when typing it into the designated cell. Would be nice not to have and use VBA but not sure if it is possible.

I attached a workbook with the example that clearly outlines what i need to do.

Thanks!

[alansidman]

Look at this link

https://www.youtube.com/watch?v=vOOuSe_s6pQ

[JOHN H. DAVIS]

Can't think of any other way maybe:

Please Login or Register  to view this content.

Note: You would have to use the return to autocomplete though.