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.
Any assistance would be greatly appreciated.