4

I'm trying to use Scenario Manager across multiple worksheets. I have all of my inputs on one worksheet and outputs on another. I'd like to set up multiple scenarios of the inputs and then show the resulting cells (on the other worksheet) in the Scenario Manager Summary. I can only find that it's possible if everything is on one worksheet.

Can someone assist?

Chris Y
  • 121
  • 2
  • 12
  • this isn't necessarily an answer to your question, but more a general "good to know"... the scenario manager is one of the least integrated tools in excel. unless you have a lot of time and like to do hard work, you might want to look for specialiced add-ins. just my 2 cents. – rohrl77 Nov 26 '15 at 12:50

1 Answers1

2

What if you just link the result cells from your second worksheet to the first one? This did the trick for me. Not the most elegant but a really simple solution.

suiluj_julius
  • 110
  • 9