Collect model outputs into a summary table

[oakwood]

I have a question around making a summary table from a model. I will try to explain this as plainly as possible.

I have a model where you can toggle 3 different inputs across two variables. The final output number of the model will vary accordingly.

I would like to create a 3X3 table with the final output for each combination of variables. Is there a way of doing this using formulas or would I need a macro?

Thanks.

[Special-K]

More info needed. Like whats your input, whats your output?

[oakwood]

So on the inputs sheet, I have two drop down lists. One is for quantity of goods (1000,2000,3000), the other is for price of good (1,2,3). There are a number of worksheets following the input sheet with calculations which reference these number. It is essentially a model which will give final profit for the year based on these two inputs. The final profit appears in one cell.

I would like to create a table outlining the profit under each combination of volume and price. It is essentially a what if - data table, but the calculation happens across worksheets, and the formula is impossible to put into 1 cell to make a data table.

I hope this clarifies it a little.