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
Attachment 347319
Bookmarks