On Apr 27, 1:58 pm, Ms. Computer
wrote:
Is there a function that if I type a person's name in on one worksheet it
automatically appears in the designated cell on another worksheet?

Seems too simple, but have you tried to make a reference to it by
using a standard = (the cell that will contain the name of the
person).

If you dont want zero's to appear, try using this then

=if(Cellwithname<"","CellwithName","")

-LT