how do i have multiple inputs and 1 output

[Neil]

i have a large spreadsheet model that essentially has 10
inputs and 1 output.
I'd like to create a second spreadsheet set up with
hundreds of rows where each column represents 1 input and
the 11th column represents the output.

How in the world would i do this?

thanks,

 

[Tim Williams]

Can your spreadsheet model be converted to a custom formula in VBA?

If it's not too complex then that might be the best approach.

Tim

 

[Neil]

Unfortunately not. It's a pretty long complicated set of
formula's NPV's etc etc etc.

Neil

 

[Tim Williams]

Then maybe the best approach would be to have a macro populate the 11th
column by linking the model inputs in turn to each of the 10 inputs on each
row.

The output would not be "live" in that changing the inputs in the multi-row
sheet would require re-running the procedure to update the output column.
If you needed this to be automatic then you could try hooking the refresh to
the sheet change event.


Tim.