Change Input - Recalculate - Paste Results for all Inputs Separately

Hi,


The attached financial model (Real Estate) calculates the final cash flows (in sheet named 7.Calculations, row 516 ) for a particular plot input in Cell G11 of the same sheet. However,the model has a list of 17 plots in the input sheet (3.Input-Plot Details). The macro must change the plot number in the cell G11, re-calculate the final cash flow (row 516) and paste all the final cash flows for 1 to 17 plots in the rows 18 to 34 in the result sheet named 8. Summary Cash Flows. The process should continue till the cash flows of all the 17 plots are calculated and pasted.

I am not a VBA expert.So, any help will be appreciated.

Kind regards,
Ritesh