Automating Scenarios and Storing outcomes

[MitchD7]

I have a fairly simple model that has 10 steps and the time & cost of each step.

ID	Activity	ActivityTime		Activity Cost
1	Step 1	0		$0
2	Step 2	50		$0.71
3	Step 3	180		$2.55
4	Step 4	180		$2.55
5	Step 5	30		$0.43
6	Step 6	5		$0.07

<colgroup><col style="text-align: center;"><col style="text-align: center;"><col span="3" style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>
</tbody>

Total: $6.30

At the end I total the cost for the 10 steps. On another sheet I have a list of changes that would affect the times for one or more of the steps.

Change	Time (sec)	Total Cost
ID1	10	$5.50
ID2	3	$3.25

<tbody>
</tbody>

I don't have an issue building the scenarios by hand, and I use the Change value (eg. ID1) as the scenario name. And there will be times the change affects more than 3 steps in a model. What I am struggling with is automating the running of scenario without changing the model and logging the ResultCell from the Summary report to the Total Cost cell for ID1. Otherwise I have tab upon tab of Summary Reports and have to make Total Cost equal to the cell on the applicable summary report.

I am assuming VBA.

Any ideas?

 

[MitchD7]

And yes I just noticed my example only has 6 steps...but that number could change.