set up auto-fill for text entry

N

NDBC

I have a list of names and tag numbers in one worksheet. They are in two
columns.

In another sheet the same names are typed in as they are allocated a rider
number. In order to prevent any typing errors I would like to set it up so
that as you type it automatically looks up the list of names and fills in the
remainder of the name based on the first few letters you have typed.
Obviously depending on the name you may still have to type in almost all of
the name before it can be differentiated from other names.

Can this be done using some of the built in options in Excel 2003 or with vb
code.

Thanks
 

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