Thanks, but I'm not sure I understand.

OK, I can re-write the workbooks and split each calculation into a different
sheet. But I need one number, based upon a few parameters, into one cell.

In effect, x = f(a, b, c, d), where f() is the model. Is there a function
in Excel 2000 that enables me to do this? What is the prepatory work? I can
take the model - the complete model - into a single, separate worksheet,
ready for the summary table to call upon its services with parameters. And
this latter bit is the thing I don't know.

(fingers crossed that there is an easy solution)


"dribler2" wrote:

i suggest that each sub-calculations be separated in different work books. Do
not place them in a single workbook or worksheet...Iteration can be powerful
and may give you the best if the parameters are linked in a circular
manner...the only thing you have to decide is on which parameter you have to
start and which parameter you have to complete all the sub-sub-multi-sub
iterations...iterations cannot bother a closed workbook...<your key to assure
that each parameter or conditions are sustained per each workbook.
4 parameters or sub-calculations = 4 workbook , for me...
good luck
--
*****
birds of the same feather flock together..



"Martin James Thornhill" wrote:

In Excel 2000, I have a complex calculation (in a worksheet) that takes 4
parameters and uses them in 4 different sub-calculations, involving
relative/conditional sub-sub-calculations. In effect, it's a model.

Having done this, I now want to pour a series of numbers into this model, to
see its effect on various combinations of parameters.

Rather than type each parameter in, copy-paste-value the result into a
summary table, how can I get Excel to run the model on call from a worksheet?

I am illiterate in VisualBasic, so anything that avoids macroes would be cool.