Hi everyone, first time poster, but I'm in a little bit of a bind here.
I have a drop down box to select 3 scenarios, which are Worst, Base and Best case scenarios for a few projections, and the data for which are hard coded on the worksheet. The drop down box populates a scenario's assumptions into a "Current Case" portion of my worksheet, according to which scenario you selected. Another worksheet then references that "Current Case" section of the first worksheet and creates the projections based on the assumptions populated there. This allows me to change the scenario I want on the drop down list and the projections will automatically change according to what scenario I'm looking at.
So, all is well and good until I think that I'd like to have an overview tab that takes specific projections from the scenarios and puts them side by side, so that I can compare a few projections across all three scenarios. I'm not sure what function or functions I can use to do this, however, without ruining my ability to change the hard codes and have the entire worksheet refresh the results, including this overview tab.
I hope I've done a sufficient job explaining my issue. If needed, I'll attach the workbook and maybe that'll help me explain what I'd need. Does anyone think they can help with this?
Bookmarks