I am trying to write a code that will do the following:
- Search column A in sheet1 for a match to C1 in sheet2
- if there is a match in column A then copy the value in column F of the corresponding row
- Paste in E14 of sheet2
Here is the code I have so far but I feel like I am way off.
Dim i As Long sheet1 = Worksheets("Budget") sheet2 = Worksheets("Summary") wsSource.Activate For i = 1 To Range("A:A").Row If sheet1.Cells(i, 2).Value = sheet2.Cells(1, 3).Value Then Cells(i, 6).Copy Destination:=sheet2.Cells(14, 5) End If Next i
Any assistance would be greatly appreciated.