P
PaulHelyer
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
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