Hi,
First time poster here hoping someone can help. I have a set of scenarios (about 500) each with 10 variables that all feed a financial model on another tab - currently with a vlookup. I would like to create a macro or use another function to return the output of the model (it happens to be an IRR) for each of these scenarios. The output is based on several cash flow tabs, etc. I have too many options to use the scenario tool manually and I'm at a loss for how to set this up differently. This is something I would use again and again with different portfolios, so I'd like to est it up right. Could someone help? Is there a way to use arrays here? I'm moderately fluent in VBA.
For example, in the numbers below, I'd like the IRR to show up based on the result in another tab based on toggling to option 1 and triggering a bunch of vlookups. I'd like to have all IRRs show up and update automatically, or maybe when I rerun a macro, instead of going through each option one by one and copying and pasting result.
Thanks,
JW
e.g.
Term State Tax Rate Escalator IRR
1 Option 1 10 40% 2% X%
2 Option 2 5 42% 1% X%
3 Option 3 6 39% 0%
...
400 Option 400 3 40% 3%
First time poster here hoping someone can help. I have a set of scenarios (about 500) each with 10 variables that all feed a financial model on another tab - currently with a vlookup. I would like to create a macro or use another function to return the output of the model (it happens to be an IRR) for each of these scenarios. The output is based on several cash flow tabs, etc. I have too many options to use the scenario tool manually and I'm at a loss for how to set this up differently. This is something I would use again and again with different portfolios, so I'd like to est it up right. Could someone help? Is there a way to use arrays here? I'm moderately fluent in VBA.
For example, in the numbers below, I'd like the IRR to show up based on the result in another tab based on toggling to option 1 and triggering a bunch of vlookups. I'd like to have all IRRs show up and update automatically, or maybe when I rerun a macro, instead of going through each option one by one and copying and pasting result.
Thanks,
JW
e.g.
Term State Tax Rate Escalator IRR
1 Option 1 10 40% 2% X%
2 Option 2 5 42% 1% X%
3 Option 3 6 39% 0%
...
400 Option 400 3 40% 3%