View Single Post
  #1   Report Post  
amy chan amy chan is offline
Junior Member
 
Posts: 4
Default 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