EXCEL: Feeding data into model and recording multiple output value

S

Stan Accy

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
 
K

Keithlo

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top