title: vba code to copy cells from previous row if a cell has a specific name
body: <p>I have a formula in Excel that will check the value of a cell and if it is True then it will copy the data from the previous cell, if it is not, cell will remain blank.</p>
  
  <pre><code>=IF(A2="Summary",B1,"")
  </code></pre>
  
  <p>I would want to create VBA code that would check the range of A, A1:A500 and if it is equal to Summary  then copy the data in the previous row from columns B, C, D, E, F, G, H, I, J, K, L.</p>
  
  <p>So some columns already have existing data in them .</p>