Iterating through values

Hi,

I have a sheet which basically takes an input value and after going through the sheet gives an output value. I would like to see how the output value changes as the input is varied eg. between 1 and 100.

Is there anyway to do this without manually inputting the values 1 to 100 in the sheet?

Originally Posted by davegugg

...If you type 1 in cell A1 and 2 in cell A2, then select both and copy down to row 100 in will show all values between 1 and 100.

Is that what you mean?

Not quite, what I have is a sheet and if you enter a value into cell A1, it gets processed and passed on from cell to cell until I get a final value at the end. What I would like is a table of input values against their output value.