I have a database of thousands of personnel and hundreds of column headings.
I want to make a 'search' function, where if I type in a name or part of a
name (followed by an asterisk), a drop down list will appear based upon the
search criteria (what I typed in). Then I want to be able to just select the
name of one individual so that I can populate a report with key info.
Currently I use index and match to bring up an individual, however whatever
name I type in followed by an asterisk gives me the first name that is
similar to what I am looking for. I need to see them all so that I can select
the right person.