A "One variable data table" should do this for you
To get a quick n easy hang of using it/setting it up,
here's a link to a blast from my past archives:
http://cjoint.com/?dwamPHboMz
One_variable_data_table_example.xls
Inspiring? Hit the YES below
--
Max
Singapore
---
"hankb" wrote:
I have a lengthy worksheet which requires a single numerical input on A1 and
it produces a single numerical output on F30. It has numerous formulas.

I would like to apply this operation to a series of input data listed on,
say, cells M1 to M20 and to produce related results on cells N1 to N20.

Is there a simple way to achieve this?