Autocomplete

T

TiMe25

Hi. I have list of products with its relevant data on sheet2. I would
like to have an autocomplete function on sheet1 based on product name
(column B, sheet2)?!

Since many products does have first word in name the same, how to
enable autocomplete from start of typing (normaly autocomplete shows a
proposal when there is a single solution).

Best regards,
 
J

JLGWhiz

If I understand the question correctly, when you begin typing the
autocomplete will offer what it thinks you are about to type. If the data
offered by autocomplete is not what you want, continue to type and
autocomplete will then offer new data based on what you typed. You can
continue this process until it finds the data you want. I am not sure if
the offerings are in alpha/numeric order or if they are in the order of
original entry, but the offerings are based on a character by character
comparison of what the user types in.
 

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

Top