Yes that works when I want to import the whole list in the same order each time, but I have a list of 600 names.
What I need is an auto text system where I just start typing the first letters of a name and all of the people with those first letters appear.Then I can select which one to input...
I use excel to create a daily document that I enter people's names into.
The names are not always in the same cell.
How can I create an Auto Text from a list of hundreds of people names.
I would type in any cell or cells I have determined and if I type "a" then a list of all the people that...