drop down box
Thanks a lot. This works for me, I am very greatful.
Thank you
"Toppers" wrote:
Look at Data= Validation
Create your list
in Data Validation:
Allow: List
Source: your list e.g A1:A10
If you want the list to be on a different sheet to the entry cell, then make
the list a named range (InsertName=Define= ....) and then in DV set the
Source: '=listname' (without the 's & where listname is your named range)
HTH
"oasalako1" wrote:
I am trying to have a drop box on a cell, so I can insert several names and
pick up whichever one I want
e.g
A. PRO-KING
B. PRO-QUEEN
C. ALISTAIR
D. NORMAN
E. ETC
I NEED ALL THIS TO SHOW IN A CELL AND I WILL NOW PICK THE ONE I NEED INSTEAD
OF HAVING TO TYPE THEM OVER AND OVER AGAIN.
ANY HELP, PLEASE
|