I have a sheet that takes 10 input parameters and a whole bunch of caluculations.
Now I would like Excel to do the calculations on another array of input parameters, without having to copy the sheet.
Actually, I would like to be able to easily switch between different arrays of input parameters. Ideally, I can store these input parameters for all scenarios on a different sheet, and then select the desired on in the main sheet using a drop box.
Can somebody point me into the right direction? Does anybody know about an example for this?
Thank you! J.