Excel macro to loop through range until value found, populate range below found cell with formula
<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>