Hi friends,
Does anyone know of a way to do scenario/sensitivity analysis with input parameters spread across multiple workbooks?
I have two workbooks with 27 tightly coupled worksheets and have multiple inputs spread over them. Is there any way I can do a "what-if" or "scenario analysis" without collating all the inputs and calculations of the 27 worksheets on one worksheet? All examples I have seen use information contained on one worksheet?
I have been searching the internet for some guidance for the last 2 days but were unable to find any solution to this problem. Any guidance of where I can get information on this?
Regards
Dan
Bookmarks