Auto copy text between cells

[Rhodestransit]

How can i auto copy text between cells without putting the formula in the cell?
I dont want to put in =C3 in cell F3
But i want F3 to have the same data that i enter into C3

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then Target.Offset(, 3) = Target.Value
End Sub

 

[Rhodestransit]

Nothing happens when i click view code

 

[VoG]

Not clear what you mean. Which version of Excel are you using?

 

[Rhodestransit]

Using Excel 97
I right click on the tab and nothing opens.

 

[VoG]

I can't test with anything that old. Try this: press ALT + F11 to open the Visual Basic Editor, in the Project window (normally top left) double click the sheet that you want to apply this to. Does a code window open? If so paste the code into the white space on the right (N.B. delete any code that is already visible first).

 

[Rhodestransit]

Still i get nothing, thanks anyway

 

[VoG]

Nothing happens if you press ALT + F11?