title: VBA Auto Key In Data
body: <p>I have 2 main sheets at play here: 
  S1 &amp;
  S2</p>
  
  <p>S1 is a supply allocation form that has loads of past records and has a date cell which I can change. S2 is basically just where i would manually copy and paste my allocation of supply into. It is a long page filled with dates at the top which I have to manually check for in order to paste the supply allocation at the right date slot. </p>
  
  <p>How can I have it so that the VBA checks for the date I set at S1 on a row of dates in S2. Then, copy and pasted my column of order(from S1) one cell below the date matched in S2?</p>