I have a number of equations containing range names in a massive excel spread sheet that would take days to alter manually as the regular autofill function does not seem to work for this.

Here an example:

=(cost_1*component_demand_1+failure_1*cost_1+failure_1*installation_cost_1)/number_of_operators

I would like the cell below this one to read:

=(cost_2*component_demand_2+failure_2*cost_2+failure_2*installation_cost_1)/number_of_operators

This should continue down the entire column and finish with:

=(cost_100*component_demand_100+failure_100*cost_100+failure_100*installation_cost_100)/number_of_operators

I have about 20 such equations that need to be altered so it would take me countless hours to do manually. Is there a way of automating this process?

Thanks in advance!

Ian