No sorry. I guess I should rephrase. That wasn't what I meant. Under the Formulas tab in the defined names area, I can create a drop-down list. When I finished creating my list that I wanted, I went to type in where the cell is located and it only allows me to click the drop down arrow and search for the name that I want. I was hoping that instead of always clicking on the drop down arrow, I could just start typing in the name and it would predict or forecast the name that I want. I have a very long list of names, in the hundreds and it is a pain to have to always select the drop down arrow and scroll down to locate it. Not very efficient.
|