Hello,

I have a set of 40 inputs that are used to calculate 1 output. I have 4
scenarios (each with 40 inputs) and wish to compare the outputs of 4
scenarios side-by-side. The Scenario Analysis tool does this, but I want to
be able to quickly change the value of 1 input in 1 scenario and watch a
table (with the 4 scenario outputs) on the worksheet automatically update.

The very slow way to do this is create the scenarios and create a summary
table. Then change one value with the scenario edit option, and calculate a
new summary table, then copy and paste the output to the original worksheet.

Your help is very much appreciated - this will help me explain to colleagues
what I am doing when I sit in front of Excel all day.

Thanks,
Ben