Does anyone know of a way to do scenario analysis with input parameters
spread across multiple worksheets?
I have 20+ tightly coupled worksheets in my file and have multiple inputs
spread over them. Is there any way I can do a "what-if" or "scenario analyis"
without collating all the inputs on one sheet ?
Thanks in advance...
Zapphod