EXCEL SHEET FORMULA [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

how can i change the name in colone A automaticly if i changed from colone R ?
exemple: if i put ROULA in colone A and go and put NANA in colone R i nbeed ROULA to change automaticly to NANA

REGARDS,

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
you mean whatever you have entered in A1 whne R1 is entered that value will be entered in A1 also

right click the sheet tab click viewcode and copy this event code


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$R$1" Then Exit Sub
Range("A1") = Target
End Sub


if this is confirm

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!