I have a spreadsheet that requires a data input at A1 to give an answer at A50.
I have a range of data in rows A60 to G70 that needs entering in turn into A1


The answer produced @ A50 then needs to appear under the data row. So data in A60 when entered into the sheet, the answer will appear in cell A61 and so on

I think this is called sensitivity analysis, but how the heck do I do automatically.

Kind Regards, Paul