data sheet cell F6 to equal sheet 1 tab

[Cgbilliar]

Can I take the name ( John Doe ) in cell F6 on my data sheet and have it
automatically show up on sheet 1 tab. I am very new at this please make it as
clear as you can.

My view code looks like this below.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

Thanks.

 

[Frank Kabel]

Hi
in this code window enter the following code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Intersect(Target, Me.Range("A1")) Is Nothing Then _
Exit Sub
On Error GoTo errhandler
Application.EnableEvents = False
Me.Name = Target.Value
errhandler:
Application.EnableEvents = True

End Sub

Also see:
http://www.cpearson.com/excel/events.htm