Replicate model on one sheet

[greglittle]

Hi all, I have a complex financial model that spans multiple sheets. I was wondering if anyone knows of an add-on or some code that will replicate the model (calculation dependency tree) onto one worksheet. If not I will have to reconstruct the entire model onto one sheet manually so that I can have multiple instances for Monte Carlo analysis (huge time waster and could introduce significant errors).

Example (Current Workbook):
Sheet1 - C1 Formula = A1+B1
Sheet2 - B1 Formula = C12*B15
Sheet3 - A1 Formula = sum('Sheet1!'C1,'Sheet2!'B1)

New Sheet Example:
A1 = 'Sheet1!'A1 | B1 = 'Sheet1!'B1 | C1 = A1+B1 | D1 = 'Sheet2!'C12 | E1 = 'Sheet2!'B15 | F1 = D1*E1 | G1 = sum(C1,F1)

Thank you for any help/suggestions!

[bassinator]

I'm new with VB but hell, my financial spreadsheet also complex, maybe i can help, you got a living example that I can visualize?

[greglittle]

Here is an example. Thanks.

Sample.xlsx

[bassinator]

Okay, in the example, which sheet you want to replicate (Sheet1)? and why do you want to replicate? Do you have many files you must enter in this? or anything that could help me figure out something for ya,

I'll wait for your comments

[greglittle]

I don't want to simply replicate the sheet, I want to replicate the model as found in the three sheets into the format found on the New Sheet tab. The real model I am using is much more complicated, but I am wondering if there is an add-on or if someone knows code that can analyze a model and then replicate into one row stretched horizontally (like on the New Sheet tab). Thanks!

[bassinator]

Give me few minutes

[greglittle]

Sorry, let me be clearer. I do not want to replicate the model in the sample. I want to replicate my extensive financial model into a format like that in the New Sheet tab on the sample file. So, an add-on or code would analyze the calculation dependency tree and then regurgitate the tree into a horizontal format on one line. That way multiple instances of the model can run in parallel below to generate Monte Carlo data.

[bassinator]

Sorry, let me be clearer. I do not want to replicate the model in the sample. I want to replicate my extensive financial model into a format like that in the New Sheet tab on the sample file. So, an add-on or code would analyze the calculation dependency tree and then regurgitate the tree into a horizontal format on one line. That way multiple instances of the model can run in parallel below to generate Monte Carlo data.

Here's sample, go to View > Tab>Macros Run it. (Or Developer, Macros, Run GregMacro) / Make sure to enable macros before.

Modify as you please with your current data,

Let me know if it's something similar to that you were looking for.

PS. Sorry for the wait, i was eating buritos :P