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,

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" wrote in message
...
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,

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

Neil
-----Original Message-----
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" wrote in
message
...
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,


.

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.









"Neil" wrote in message
...
Unfortunately not. It's a pretty long complicated set of
formula's NPV's etc etc etc.

Neil
-----Original Message-----
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" wrote in
message
...
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,


.