Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to create a pull down menu for selection? | Excel Worksheet Functions | |||
Pull Down menu's | Excel Worksheet Functions | |||
Pull Down Menu Bar | Excel Discussion (Misc queries) | |||
pull down menu | Excel Programming | |||
Pull Down Menu's | Excel Programming |