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