VBA- Extend formulas of columns or remove if not needed

[aeroguy1]

Hello,

I am looking for help with a code that will help automate some financial statements. It is a standard tool that has the first year and the last year as an input. Based on the last year of analysis needed, the VBA code would extend (drag) the formulas to the column needed.

Also, I built the worksheet to Year 1+ 15 years, so if the statements are only needed for a shorter period of time, the code would delete these.

Thank you!