Iterations of complex calculations
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.
|