title: VBA Macro Code to Auto Fill value
body: <p>I have a macro code where I want the value of column Q to be autofilled based on first value of cell Q2 till last active row based on adjacent column last row (Say column P). The issue is that I do not want starting point to be fixed at Q2, as the row will keep on changing once first auto fill is done. </p>
  
  <p>For example - first I might want to autofill Q2 to Q10, assuming last row as row 10, but then last row will become row 20, and hence I want to copy Q11 to Q20 and so on. Any simple macro to do this? </p>
  
  <p>Any support is highly appreciated.</p>
  
  <p>Thanks
  Manis</p>