VBA copy and paste into specific row based on drop down and specific column

[DNicole]

I am new to VBA and trying to write the code to do the following. In sheet1 D7 I have a drop down to select a project name and then in D14 and D17 two other drop downs for yes or no answers. In sheet 2 I have all the projects listed in column A and then various other information in the other columns. I want it to match sheet1 D7 with the correct row in sheet2 based on the project name in column A and then paste the values in D14 and D17 to columns E and I in sheet 2

 

[Sahak]

Hi Nicole,
Try this
After running VBA code below:

Sub Match_And_Copy()
    Dim MtchVal As Long
    MtchVal = Application.WorksheetFunction.Match(Range("Sheet1!D7"), Range("Sheet2!A2:A15"), 0)
    Range("Sheet2!E1").Offset(MtchVal).Value = Range("Sheet1!D14").Value
    Range("Sheet2!I1").Offset(MtchVal).Value = Range("Sheet1!D17").Value
End Sub

According to your selection on D7 in sheet1 (in my example: "Project_29", the values from D14 & D17 from sheet1, will go to columns E and I, sheet2

 

[DNicole]

Hi Nicole,
Try this
After running VBA code below:

Sub Match_And_Copy()
    Dim MtchVal As Long
    MtchVal = Application.WorksheetFunction.Match(Range("Sheet1!D7"), Range("Sheet2!A2:A15"), 0)
    Range("Sheet2!E1").Offset(MtchVal).Value = Range("Sheet1!D14").Value
    Range("Sheet2!I1").Offset(MtchVal).Value = Range("Sheet1!D17").Value
End Sub

According to your selection on D7 in sheet1 (in my example: "Project_29", the values from D14 & D17 from sheet1, will go to columns E and I, sheet2
View attachment 58588View attachment 58589

Thank you this is exactly what I needed!

 

[Sahak]

You are welcome