6,210
社区成员
发帖
与我相关
我的任务
分享
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
ActiveWorkbook.Worksheets("Sheet2").Range("A5").Value = Target.Value
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$5" Then
ActiveWorkbook.Worksheets("Sheet1").Range("A1").Value = Target.Value
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
ActiveWorkbook.Worksheets("Sheet1").Range("A5").Value = Target.Value
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$5" Then
ActiveWorkbook.Worksheets("Sheet2").Range("A1").Value = Target.Value
End If
End Sub