I have a Worksheet that EE has helped me with that needs "adjustment".
What I'm trying to accomplish: I am trying to have the model automatically expand (by years up to 10) by changing a cell (D3) and automatically cut/paste the cells and formulas in the first column (Column E5-E9) and place that data in any column that has a number in E4 (based on the change). If the number in D3 is changed, then the model adapts to the change by deleting or adding data in the appropriate columns. This is simply a dynamically expanding array.
You will see in the sample I have attached that presently the model doesn't work accurately; with the formulas "hardcoded" into the macro itself, they are not easy to change. In the example provided, the numbers are "Summed" rather then subtracted due to the hardcode. If the formula was correct in cells E7 and E9, then you would see the right answers.... That is why I need a simpler, cut/paste approach.
Thank you in advance,