Excel help please

[coolVariable]

I have a rather complicated excel model (with calculations stretching over multiple sheets).

There is an input cell, multiple assumption cells for the calculations and one cell with the result.

I would like to build a table with a range of input values and results.

For this the input cell would need to be fed from a range of values (e.g. in a table) and the results recorded to the table.

I think this is possible (or at least it should be) but I have absolutely no clue how to do it.

Any help?

I assume I will need a macro for this?

 

[coolVariable]

up.
still cannot figure out how to do this ... any help?

 

[CycloWizard]

Excel really isn't ideal for this sort of work, but it can be done. The simplest way is to make a separate worksheet to store your results in. Change the input values, calculate the spreadsheet(s), and record the results. If you just make a row where each cell is pointing to one of the input variables, then you can easily copy them and paste values into your "results" sheet.