Text mapping

M

Ms. Computer

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

LT

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?
Click to expand...

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
 
M

Ms. Computer

I did try it but wasn't looking close enough. I was doing that but with
merged cells and forgot to delete the end of the range.
Thank you for your quick response.
 
C

challa prabhu

Hi,

1. Press the Shift key and select those worksheet you want group.
2. Then, when you enter a value in any cell the sheet, the data will
automatically be enetered in the other sheet you grouped.

Challa Prabhu
 
Top