title: Excel macro to loop through range until value found, populate range below found cell with formula
body: <p>I have a large table, sometimes with hundreds of rows.<br>
  This table is generated by another application that exports to excel.</p>
  
  <p>One column has the heading "Adjusted Price".<br>
  I want all the rows in this column to contain a formula (presently they're all 0's).</p>
  
  <p>I want to automate this process because the table gets regenerated all the time.</p>
  
  <p>This column may not always be in the same place. <strong>So I need a macro that can find this column ("Adjusted Price") and then fill all the cells in that column with a formula (with the exception of the first row of course).</strong></p>
  
  <p>Can this be done?</p>
  
  <p>Thanks in advance :)</p>