I have a spread sheet that when you enter a varaible at the top say A1
you get an answer at the bottom say at L1.

I need to perform what I think is called a sensiitivity analysis on
this sheet.

I have a row of data say Z1 to Z10 and each value within this row needs
entering into the sheet individually at A1. The answer the sheet gives
at L1 then needs to appear under the corresponding input data row. So
the data in cell Z1 when put through the sheet the answer from this
will appear at AA1 and so on.

I'm sure this is very basic for a spreadsheet, but how the heck do I do
it.

Kind Regards, Paul


--
PaulHelyer
------------------------------------------------------------------------
PaulHelyer's Profile: http://www.excelforum.com/member.php...o&userid=31716
View this thread: http://www.excelforum.com/showthread...hreadid=518442