Hi friends,
Does anyone know of a way to do scenario/sensitivity analysis as well as using data sheets with input parameters spread across multiple workbooks?
I have two workbooks with 27 tightly coupled worksheets with multiple inputs spread over them. Is there any way I can do a "what-if" or "scenario analysis" or compile data sheets 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 (and read some of the documentation on this website) for some guidance for the last few days but were unable to find any solution to this problem. Any guidance of where I can get information on this?
Regards
Dan
Does anyone know of a way to do scenario/sensitivity analysis as well as using data sheets with input parameters spread across multiple workbooks?
I have two workbooks with 27 tightly coupled worksheets with multiple inputs spread over them. Is there any way I can do a "what-if" or "scenario analysis" or compile data sheets 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 (and read some of the documentation on this website) for some guidance for the last few days but were unable to find any solution to this problem. Any guidance of where I can get information on this?
Regards
Dan
