ExcelBanter - Linking and displaying

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?