10 input cells and 1 output cell

[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 unique rows where the first 10 columns
represent 1 input and the 11th column represents the
output.

How in the world would i do this?

thanks,

Neil

 

[JE McGimpsey]

Unfortunately, though it's been proposed, using a worksheet as a
template has not been implemented in XL.

One way would be to use a macro to transfer inputs to the first sheet,
then transfer the result to the second sheet. Something like:

Assume inputs in Sheet1!A1:J1, the output in Sheet1!J1000, and the table
of inputs in Sheet2!A2:J2:

Public Sub CycleModel()
Dim rCell As Range
Dim rInputs As Range
Dim rOutput As Range
Dim rTable As Range

Application.ScreenUpdating = False
Set rInputs = Sheets("Sheet1").Range("A1:J10")
Set rOutput = Sheets("Sheet1").Range("J1000")
With Sheets("Sheet2")
Set rTable = .Range("A2:A" & _
.Range("A" & .Rows.Count).End(xlUp).Row)
End With
For Each rCell In rTable
rInputs.Value = rCell.Resize(1, 10).Value
rCell.Offset(0, 10).Value = rOutput.Value
Next rCell
Application.ScreenUpdating = True
End Sub

 

[Neil]

sounds difficult, but at least it's a start.

thanks,
Neil

 

[Max]

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 unique rows where the first 10 columns
represent 1 input and the 11th column represents the
output. How in the world would i do this?

Perhaps another option would be via a one variable data table ?
For some previous suggestions on how the data table could be set up ..

Try : http://tinyurl.com/6kdxh

Or, if the 10 inputs (besides the output) are also dependent
on random numbers, then maybe:

http://tinyurl.com/4p2fa
http://tinyurl.com/6scax

 

[Neil]

Max,

thanks, but i have the reverse case. Specific, non
random inputs and a single output. I think the one
variable data table works in reverse, (many outputs, but
one input)

any thoughts?

Neil

 

[Max]

thanks, but i have the reverse case. Specific, non
random inputs and a single output. I think the one
variable data table works in reverse, (many outputs, but
one input)

any thoughts?

Looks like a 180 degree mis-read on my part then, sorry.
I've no further thoughts to offer ..