J
Jack Mallinckrodt
I have a complex black-box modeled on a single worksheet. n identifiable
cells are input parameters, m identifiable cells are output results.
I want to plot some of the outputs as functions of some of the inputs. For
this I need to make a table of which the first n columns are manually input
parameters, and the next m the spreadsheet results. I need something like
an enhanced "scenario" macro or function to do this, for each row, take
the first n cells (columns), copy those values into the corresponding input
parameter cells, recalculate the spreadsheet, and copy the results cells
into the next m columns of the table. Then proceed to next row.
This would be like a "scenario" but with inputs taken from the first n
columns and results sent to the last m columns of each row of an array.
Is there such a thing? Would it be a feasible macro?
Thanks,
Jack
cells are input parameters, m identifiable cells are output results.
I want to plot some of the outputs as functions of some of the inputs. For
this I need to make a table of which the first n columns are manually input
parameters, and the next m the spreadsheet results. I need something like
an enhanced "scenario" macro or function to do this, for each row, take
the first n cells (columns), copy those values into the corresponding input
parameter cells, recalculate the spreadsheet, and copy the results cells
into the next m columns of the table. Then proceed to next row.
This would be like a "scenario" but with inputs taken from the first n
columns and results sent to the last m columns of each row of an array.
Is there such a thing? Would it be a feasible macro?
Thanks,
Jack