Sending values?

[bobmc]

Is there a way to SEND a value from one cell to another, overriding anything that may have been entered into that cell?

 

[Mudface]

Not to sure what you mean, but entering =A1 into cell B1 will show always show the value in A1 (or a zero if A1 is empty).
This message was edited by Mudface on 2002-03-14 12:08

 

[smozgur]

Open VBA editor then double click on the Sheet that you want to apply transferring cell values. And select the Worksheet on module and Change event then write this code there.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$A$1" Then Range("A2").Value = Target.Value
End Sub

to change A2 cell value to A1 value when A1 changed.

regards
suat
This message was edited by smozgur on 2002-03-14 12:12