Hello. I have a lot of cells where there is a data validation dropdown I created. the data validation is getting longer and longer and I want now to be able to just type few characters and the cell will auto complete the values from the data validation list.
For example:
Data Validation.jpg
The values for the data validation dropdown in Sheet A1 is in Sheet2 A1.
Bookmarks