title: Find values in a worksheet with two criteria matches, copy them and paste them to another sheet with VBA
body: <p>Here is my problem:</p>
  
  <p>Sheet1 = "Interface". Sheet2 = "Data". </p>
  
  <p>Column C5:C160 in "Data" contains a list of tasks. 
  Row D4:M4 in "Data" contains a list of position types (jobs), which I have labelled with "job categories" from 1-10. The range D5:M160 contains work-hours for each task and position type.</p>
  
  <p>Values in columns E and F in "Interface" are related to columns C and row 4 in "Data" through data validation. </p>
  
  <p>What I want to do is create an advanced filter that can copy values from D5:M160 in "Data" and paste these in column G in "Interface", if the values in columns E and F "Interface" match the values in column C and row 4 in "Data" respectively, simultaneously. </p>
  
  <p>This means that it should be a macro to copy and paste values with matching multiple criteria (two criteria) from one sheet to another.</p>
  
  <p>I have tried different things, with no success. I have also tried array formulas, vlookup and sumifs with multiple criteria, but none of these seem work. </p>
  
  <p>Any ideas?</p>
  
  <p>I appreciate your help!</p>