I have a list of words in Sheet2 column A.
I have a dropdown list using data validation in Sheet1[R9], I would need help in making R9 auto complete when I type some value that matches the list without me using the mouse to use the dropdown or typing the entire word.
I have a dropdown list using data validation in Sheet1[R9], I would need help in making R9 auto complete when I type some value that matches the list without me using the mouse to use the dropdown or typing the entire word.