ham123
04-03-2019, 08:52 PM
Greetings experts,
I need help editing this code into a for next loop.
If Activesheet's Cell B11 is the same as any value in Column F from sheet "Vendor Code List" then Activesheet's Cell B13 value would be the value in Column E from sheet "Vendor Code List" corresponding to the same row.
Sub AutoPopulate()
If Range("B11") = Worksheets("Vendor Code List").Range("F") Then
Range("B13") = Worksheets("Vendor Code List").Range("E")
End If
End Sub
Any help is much appreciated! :)
I need help editing this code into a for next loop.
If Activesheet's Cell B11 is the same as any value in Column F from sheet "Vendor Code List" then Activesheet's Cell B13 value would be the value in Column E from sheet "Vendor Code List" corresponding to the same row.
Sub AutoPopulate()
If Range("B11") = Worksheets("Vendor Code List").Range("F") Then
Range("B13") = Worksheets("Vendor Code List").Range("E")
End If
End Sub
Any help is much appreciated! :)