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...
Hi,
I am trying to use this, but the sheet I want it to autocomplete is a different sheet from the one where the list is. So I have a column in August that I want to populate with employees names. The list in in sheet settings under D2:D65.
I can't seem to make this work at all, and I need to be able to give me the employees quicker so I can do data entry on the August sheet.
Can you make this work when I don't know VBA?
Thanks,
Liz
Without VBA this will hardly work,,, you do one thing,, upload the WB and mention in which column or cell you want to use it then I'll apply the VBA and send back the sheet to you ☺
- Rajesh_Sinha I saw your reply here and wonder if you'd be able to add VBA to my file as well? I also would like to allow auto complete text in a drop down list cell. Thank you!
Rajesh_Sinha Great! I will do that tomorrow. Thanks! Liz