create pull down menu
 

I would like to create a sheet for user input data to it as following example , the first column is duplicate .

name ID
==== ===
peter 123
mary 456
peter 452
tom 125
peter 544
john 524

kity 144
tom 524
vivi 521
peter 572
"
"


As you see in above , the user input the name field "peter" and "john" many times , I just would like to ask how to make the uesr no need to re-type "peter" and "john" , can it create something like pull down menu for user to select from name list or is there other method for user no need to re-type "peter" and "john" many times ? thanks

eg.
pull down menu
peter
john
mary
tom
kity
vivi

create pull down menu
 

Hi Amy,

Am Mon, 18 Nov 2013 02:07:16 +0000 schrieb amy chan:

name ID
==== ===
peter 123
mary 456
peter 452
tom 125
peter 544
john 524

kity 144
tom 524
vivi 521
peter 572

if you fill the name column without blank cells and Peter already exists
in the column you get the suggestion Peter while writing P and you can
confirm it with Enter.
For me this way is easier and faster than clicking on dropdown, looking
for the name in the list and select it.
If you want a dropdown then select the cells = Data = Data Validation
= List and put in your names as source


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2