I am trying to create a macro that will allow someone to enter information in cell#1 to have it appear in cell#2. I want to be able to have information entered in cell#2 to appear in cell #1.
I wrote this code using "Worksheet" - "Selection Change"
If ActiveCell.Row = 10 And ActiveCell.Column = 4 Then
Worksheets("Assortment").Cells(28, 3).Value = Worksheets("Summary").Cells(10, 4).Value
End If
When I enter a value in cell#1, it doesn't update until I enter something else after.
I hope this makes sense. I suppose I could write code so that it enters a formula to reference the other cell, but I was thinking there might be a cleaner way.
Thanks
Andy
I wrote this code using "Worksheet" - "Selection Change"
If ActiveCell.Row = 10 And ActiveCell.Column = 4 Then
Worksheets("Assortment").Cells(28, 3).Value = Worksheets("Summary").Cells(10, 4).Value
End If
When I enter a value in cell#1, it doesn't update until I enter something else after.
I hope this makes sense. I suppose I could write code so that it enters a formula to reference the other cell, but I was thinking there might be a cleaner way.
Thanks
Andy