Copy text automatically to another worksheet

[Guest]

How can I apply a function such as "=Worksheet!B6" for a cell containing text
(i.e. a name and/or a date) rather than numbers or a function?

 

[Don Guillett]

Did you try it before asking?

 

[Gord Dibben]

Sally

=Worksheet!B6 works fine with text and dates as well as numbers.

Don't forget the target cell has to be formatted same as source cell if the
source cell is a date.

Have you tried it and gotten an error or what?

Assuming you have a worksheet named Worksheet.

Gord Dibben Excel MVP