View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Martin James Thornhill Martin James Thornhill is offline
external usenet poster
 
Posts: 7
Default 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.