VBA to Copy Multiple Column Formula Down

[cpadilla0024]

Hi,

I am trying to save steps in a data set that I analyze very regularly. The row length overlaying data that the formulas are reading from change. I have posted more details in my attachment.

Please help! Thanks!

 

[Fluff13]

How about

Sub cpadilla0024()
   On Error Resume Next
   Range("K:L").SpecialCells(xlFormulas).ClearContents
   On Error GoTo 0
   With Range("K2", Range("A" & Rows.Count).End(xlUp).Offset(, 11))
      .Formula = Array("=+LEFT(E2,1)&""XXX""", "=IF(A2<0,""NEED BUDGET"",""OKAY"")")
   End With
End Sub