Hi,

I have a detailed calculation in Excel and wish to run that calculation
for a range of input values. I can use the Tools, Scenarios but this
requires that I manually enter each of the input values. I am looking
for a way to get the input values from a list of values in Excel.

To simplify. I have a range of input values in the range A1:A100. I
wish for the result of the calculation for each input value to be
placed in the cells next to the corresponding input value., i.e.
results to ge on the range B1:B100.

For arguments sake lets assume that the input cell for the calculation
is in cell E1 and that the result of the calculation can be found in
cell G30. The calculation does not lend itself to being placed on a
single line as it consists of multiple sheets using lookup tables.

I could write a macro to take each cell in turn from a named range
(InputRange), place it in the InputCell, collect the resulting value
from the OutputCell and place it in the cell adjacent to the
corresponding cell in the InputRange.

Is there a way to do this in Excel without writing a macro?

Any assistance will be appreciated.

Sean