Forum Discussion
Auto complete text in a drop down list cell
Hi everyone, Trying to do a spreadsheet and figured out how to make the drop down list box (yay). But I would like to have the option of auto completion of words when I type a few letters in...
Rajesh_Sinha I followed along well until it said "reach to linked cell ..." sorry.
I have my Data on one sheet, and the form on the other. How do I link it from sheet 3 (data) to be on the combo box on sheet 1?
Or no no?
Have you tried with VLOOKUP, or even better, XLOOKUP to link different sheets? They worked great for me. Good luck with that 🙂