A combo box behaves just like that!

Regards,
Stefi

€žA.Chase€� ezt Ã*rta:

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!