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