title: In VBA, how do i create a code where it matches dates from 2 sheets and paste data in to that matched date as values? Can't use vlookup for this
body: <p>So I have 2 sheets on Excel, Calculator and Results Sheets.</p>
  
  <p>On the calculator sheet, Cell A1 has the current date. On the results sheet, Cells A2:Infinity have dates increasing by day.</p>
  
  <p>I am trying to write a program where IF Cells A1 from Calculator sheet are equal to cells A2:Infinity from the Results Sheet, it will copy paste the data cells range C2:C7 from the calculator sheet to the matched date on the results sheet as Transposed Values to the cell range (B:G)</p>
  
  <p>VLOOKUP wont work as the previous data would be gone because of a change of dates.</p>
  
  <p><a href="http://i.stack.imgur.com/AftxX.png" rel="nofollow">Results Sheet</a></p>
  
  <p><a href="http://i.stack.imgur.com/N0Rdg.png" rel="nofollow">Calculator Sheet</a></p>
  
  <p>Any help would be appreciated!</p>