Hi all,

I am facing an issue in my financial model. I created a worst, base and best case scenario and a switch to control the input variables. The financial statements all work well.
However, the problem is how to link the values into the Executive Summary sheet.

For instance, the Net Profit in the best is $12M, base $10M and worst $8M. How do I link the cells in the executive summary to show this.

For instance, 1. Best Case scenario, cell A1 = [LINK] will show $12M 2. Base Case scenario, cell A2 = [LINK] will show $10M

Right now, the Net Profit value is in a single cell, which dynamically changes based on the switch. How do I link the Net Profit from each of best / base / worst case scenario to different cells in the Executive Summary? Short of copying and paste... which means it's not dynamic.

Thanks.Fi