VBA to copy formulas based on cell value, looped in range

Hi.
I am needing to loop through rows of a range (A4:AC & last row of data), checking a particular cell in each row (Column AC) for a value. After matching various values, I need to copy formulas from another part of the sheet to the row that is being searched.

I cobbled together a portion of what I think might work, but I am stuck on how to tell it which row to paste the formulas to. (I'm sure this snippet of code is clunky, so any adjustments are welcome.)

Please Login or Register  to view this content.