MurraySMTH
Board Regular
- Joined
- Jun 30, 2020
- Messages
- 81
- Office Version
- 2016
- Platform
- Windows
Hello all,
I have a code that i wrote to note that A2 and B2 are equal on Sheet 4,
If J2 on a another sheet (Template Upload) will match A2 on (Sheet4) then paste B2 of (Sheet 4) to replace J2 sheet (Template Upload)
Sub Sheet4_templateupload()
Worksheets("Sheet4").Range("A2").Value = Worksheets("Sheet4").Range("B2").Value
If Worksheets("Sheet4").Range("A2").Value = Worksheets("Template Upload").Range("J2").Value Then
Worksheets("Sheet4").Range("B2").Copy _
.Paste Destination:=Worksheets("Template Upload").Range("J2")
End If
End Sub
This is Sheet 4
ColumnA ColumnB
Template Upload
In summary, If Column A of Sheet 4 and Column J of the Template Upload Sheet match, then replace with B2 with the match of A2 of sheet 4.
Hope this is clear!
I have a code that i wrote to note that A2 and B2 are equal on Sheet 4,
If J2 on a another sheet (Template Upload) will match A2 on (Sheet4) then paste B2 of (Sheet 4) to replace J2 sheet (Template Upload)
Sub Sheet4_templateupload()
Worksheets("Sheet4").Range("A2").Value = Worksheets("Sheet4").Range("B2").Value
If Worksheets("Sheet4").Range("A2").Value = Worksheets("Template Upload").Range("J2").Value Then
Worksheets("Sheet4").Range("B2").Copy _
.Paste Destination:=Worksheets("Template Upload").Range("J2")
End If
End Sub
This is Sheet 4
ColumnA ColumnB
Template Upload
In summary, If Column A of Sheet 4 and Column J of the Template Upload Sheet match, then replace with B2 with the match of A2 of sheet 4.
Hope this is clear!