EXCEL: Feeding data into model and recording multiple output value
 

I have an Excel 2003 model, that has 5 inputs.
The model has 5 outputs.

I'd like to be able to specify different groups of the 5 inputs (lets say 3
groups), and then see the 5 output's, per group, on the same worksheet, all
updated dynamically (assuming I change the model algorithm, or some other
inputs).

The 'scenarios' function sort of does this, but Im after a single sheet,
dynamic solution. Im willing to code VBA or C++ if needed to achieve this.

Is this possible?
If so, any hints please?


Regards

N

EXCEL: Feeding data into model and recording multiple output value
 

VBA is your best tool (unless your problem can be solved using built-in Excel
functionality) since it is the programming language designed for MS Office
(Excel in this case).

"Stan Accy" wrote:

I have an Excel 2003 model, that has 5 inputs.
The model has 5 outputs.

I'd like to be able to specify different groups of the 5 inputs (lets say 3
groups), and then see the 5 output's, per group, on the same worksheet, all
updated dynamically (assuming I change the model algorithm, or some other
inputs).

The 'scenarios' function sort of does this, but Im after a single sheet,
dynamic solution. Im willing to code VBA or C++ if needed to achieve this.

Is this possible?
If so, any hints please?


Regards

N