set up auto-fill for text entry
 

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