How do I create multiple drop down lists that auto completes after typing the first few letters, instead of having to search through a large list?
See attached excel file of what i basically have.
i have a number of slots under dates on one sheet. On another i have a dynamic range of names to assign to the slots. the number of slots/dates as well as list of names are much larger on the actual worksheet.
i would like to be able to type the first few letters and have each drop down list suggest a name.