Posted: 7/1/2009 9:15:22 AM EDT
|
Can I set up a column to autofill a cell (once you type a few letters) using only options from a list on another worksheet?
I initially tried a drop down menu, the list in question has > 50 names. Also I would like to start typing in the cell the 1st few letters of the name from the list and it fill in the rest (kinda like what Outlook does in the address bar). If the field has a drop down menu it won't let me do that (unless that name is already somewhere in the column). Thanks. |
|
Quoted:
Yes, just create a named range in the other worksheet, and use Data Validation for the column in question. I can send you an example if you want, just pm me your email. Is this the same as developing the drop down menu? Initally I tried that, but when I enter text in the cell, it won't autocomplete from the range of cells I made the drop down from. |
|
Quoted: Quoted: Yes, just create a named range in the other worksheet, and use Data Validation for the column in question. I can send you an example if you want, just pm me your email. Is this the same as developing the drop down menu? Initally I tried that, but when I enter text in the cell, it won't autocomplete from the range of cells I made the drop down from. Yes, and I apologize for skimming over that part. I was under the impression that my worksheet was autocompleting, but it was actually just excel's 'smart fill' that was predicting the contents of the new cell based on previous columns' content. If you're feeling adventurous, follow the instructions at the following link to implement what you want using VBA. http://www.contextures.com/xlDataVal14.html |