Hello,
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.
Code
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
Display More
Any assistance would be greatly appreciated.
Many thanks