Creating a scenario summary/table of values that automatically updates??

Hello everyone!

Is it possible to create tables on a different sheet to a scenario analysis that automatically update when values in the said sheet change??

I have attached the workbook... Basically I am trying to replicate the values of cells (Sheet 1) BO43:BT43 and BO45:BT45 (for each scenario) to:

- Sheet 2 cells C5:E10 and J5:L10 respectively

and the same for Sheet 3

- cells BO43:BT43 to (Sheet 3) C12:E17

Thanks a million in advance!!

W

Model with NPV and Cash Flow analysis.xlsm

If you need to replicate cells just type = then switch to the sheet and click on the cell or range of cells. The end result will probably look something like this ='ANZ Serv Projection'!BO46:BT46
Is that what you're looking for?

If you need to replicate cells just type = then switch to the sheet and click on the cell or range of cells. The end result will probably look something like this ='ANZ Serv Projection'!BO46:BT46
Is that what you're looking for?

Hi bmouse,

Thanks for getting back to me... I was actually looking to create a table that shows the values of those cells for each scenario (simultaneously, side by side to) not just the values resultant from the scenario selected at time. Basically I am hoping to create something similar to the output of the 'summary' function of the scenario manager that is dynamic (the summary function doesn't automatically update).

Cheers

W