If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|