I want to enter names in one worksheet and display "full" in another? Can
anyone tell me how to write this formula?

Can you explain more clearly what you want? Give examples of data and columns
plus the logic required. e.g If A2= xyz then ......

"CJB" wrote:

I want to enter names in one worksheet and display "full" in another? Can
anyone tell me how to write this formula?

I'm not very good with excel, I apologize. I want employees to be able to
enter their personal information for health screen signups. they will put in
their name, birthdate, department, phone, etc. they will have to pick a date
and time that is specified. i thought I would do this in one worksheet.
But in order to keep their information confidential, when another person goes
to sign in then I want that date and time with their name and personal
information to show that is full. in otherwords I want all employees to
enter their information in a date and time they choose but when they veiw the
worksheet they see "full" that date and time is full - pick another. Does
that make any sense? I know how to put information in one worksheet and will
it update it in another, I don't know how to display something else?

"Toppers" wrote:

Can you explain more clearly what you want? Give examples of data and columns
plus the logic required. e.g If A2= xyz then ......

"CJB" wrote:

I want to enter names in one worksheet and display "full" in another? Can
anyone tell me how to write this formula?