Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
auto text entry | Excel Discussion (Misc queries) | |||
Auto fill cell entry | Excel Discussion (Misc queries) | |||
Auto-Entry of text from another worksheet | Excel Discussion (Misc queries) | |||
How to auto-fill text based on text in another cell | Excel Discussion (Misc queries) |