Copy text automatically to another worksheet

S

sally

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?
 
G

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
 
Top