Auto-Completion on Drop-Down Lists

A

A.Chase

I am creating a payment request form for our accounts department at work, and
one of the columns is for "account name," which we presently have linked via
a drop-down list to another sheet by that name. Ideally, I'd like for
employees to be able to just type the first letter of their account name in
the drop-down box and have it auto-complete, as there are several hundred
entries to scroll through. Is this possible? Right now, auto-complete only
reads the cells in that column on the same sheet, which are not applicable.
I've already alphabetized the list for easier access, but is there anything
further I can do to make the process simpler and less time consuming for them?

Thanks!
 
S

Stefi

A combo box behaves just like that!

Regards,
Stefi

„A.Chase†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Drop down lists 1
Drop down lists and autofill 3
problem with drop down lists 1
Using drop down lists 2
How do I auto populate based on a drop down list? 0
Drop Down Lists - Shrinking the List 5
auto fill or auto search from a list or drop-down list??????? 9

Top