I have seen many similar questions and a lot of great answers, so I am hoping someone can help me. I have no knowledge of macros...so please be kind.

I have a "cash burn" schedule that I have built and it works great, but I would like to automate it even more.

I would like to have it add/subtract rows with calculated formulas based on user input. At the top of the sheet, I input the "Total Cost" in F2 and the "Duration" in K2. Based on the Duration(K2) I would like the numbered rows beginning at Row 4 to expand and/or contract keeping the formulas and row numbers (+1). The formulas distribute cash over a given time period.

Here is the file:
Construction Spend.xls

Thanks in advance.