1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto Text complete ?

Discussion in 'Ask an Excel Question' started by Whistler, May 19, 2017.

  1. Whistler

    Whistler New Member

    Messages:
    2
    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 start with "a" would show and I would click on the correct name?
    All the list solutions I have found only work for a preset cell and the auto fill doesn't work if there are empty cells below the list.
    Thank you.
    Using Mac Excel 2011
  2. vletm

    vletm Well-Known Member

    Messages:
    2,800
    Whistler
    1) Have a list of names in some sheet
    2) Select it
    3) Excel > Preferences... > Custom Lists > Import
    >> What is missing? so far works with my 2011.
  3. Whistler

    Whistler New Member

    Messages:
    2
    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 into that cell.

    The cells will not be the same location each time to use a drop down list.
    This will save me time and correct spelling errors on input.

    I'd rather not have the same drop down list on each cell but I guess that is an option.
  4. vletm

    vletm Well-Known Member

    Messages:
    2,800
    Whistler - yes
    Try this version ...
    Names are in 'Names'-sheet - D-column -
    1) just modify/add names as needed from 3rd row as needed
    2) You can SORT Names by activating cell D2
    3) go back to 'Sheet1'.
    Using:
    Select any cell from B-column (from row 3) and
    ... select the 1st letter
    ... after that
    ... make new selection - now names

    Attached Files:

    • DD.xlsb
      File size:
      53.1 KB
      Views:
      4

Share This Page