Allow Only Certain Names In a excel cell

[angushiro]

How can I set up a cell to only allow certain designated names of persons in a cell?
example: A2 can only be, Tom or Fred or whatever?
thank you

[ianh]

on the data tab there is an option for "Data Validation"
You can set your options in here.

[Fotis1991]

Hi

Make a list of the Names and name it List(for example)

Then IN A2>>Data>>Validation>>Custom>>put the formula: =A2=List

This will let you to put there, only names of the List.

Hope to helps you.

[angushiro]

Yes thank you Fotis. It does work, but what I need is that after the spread sheet is filled in with the necessary calculated field, at the bottom is a cell Named as:
ENTER YOUR NAME:_______ . There only seven persons allowed to enter there individual ]first name. The spread sheet is done daily. The sheet is protected for whereas you enter the necessay numbers but can only enter where there are no formulas>

[Fotis1991]

Hi angushiro.

The answer that I gave you, related to your specific question and I'm glad you said that it works correctly.

For the new your question, unfortunately I do not understand what is wanted!

I think,that if you attach a sample workbook, will help us very mutch.

[angushiro]

Sorry Fotis it was I not exactly doing the procedure correctly> After doing as too what you said proberly it works find > although I do find after using 2007 and 2010
excel for so long now and working at given times with 2003 a little challenging.
thank you for your support.
Angushiro