I have a file with numerous tabs of calculations, etc. that results in a nice
summary tab already created. I also have 3 "scenarios" whereby if I select
Low, Medium, or High, it filters through my calculations to show 3 different
results, depending on what is selected. What I am trying to do is create a
new tab with a basic output that shows the results of all 3 options,
side-by-side, regardless of which scenario is selected.
As an aside, does that table have a specific "name" - which I can then also
look up in Excel Help?