Hey, I'm new here and to vba so any help is greatly appreciated!
I want to be able to "link" two cells together so if you enter a value into one cell the other cell will match it, and vice versa. I can do this with two cells in the same worksheet, but I cannot figure it out if they are on different worksheets.
Here is the code I am using, and its in the "ThisWorkbook" section in "Microsoft Excel Objects" folder when you open vba.
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Address = Worksheets("LC1").Cells(1, 1) Then
Worksheets("LC2").Cells(1, 1) = Worksheets("LC1").Cells(1, 1)
End If
If Target.Address = Worksheets("LC2").Cells(1, 1) Then
Worksheets("LC1").Cells(1, 1) = Worksheets("LC2").Cells(1, 1)
End If
End Sub
I have tried several combos such as changing "Target.address (0, 0)" and nothing seems to work
Thank you in advance!
Bookmarks