This is the first time for me to ask for assistance regarding excel! and so I don't know which forum is the most helpful- I have tried one forum yesterday but no one gave me not even a hint- so I hope I get the required assistance here.

I have an excel sheet with relatively large data set. I have a formula with locked and unlocked reference cells: I want to be able to copy the formula down - so that the unlocked references change; Now the problem is that I want to copy the exact formula to the right of the second cell from top, then change the locked reference cells to the next one below. For example: If the formula in C1 is $A$5+B1, then I copy it down so I have in C2 $A$5+B2, C3: $A$5+B3.... now I want to copy the exact formula in C2 to D2 but changing the locked reference to the one below so I have in D2: $A$6+B2; afterwards I copy the formula in the second populated cell in D coloumn to E so I have in E3:$A$7+B3 and so on. Below is a table for illustration:

A | B | C | D | E | F | |

1 | $A$5+B1 | |||||

2 | $A$5+B2 | $A$6+B2 | ||||

3 | $A$5+B3 | $A$6+B3 | $A$7+B3 | |||

4 | $A$5+B4 | $A$6+B4 | $A$7+B4 | $A$8+B4 |

<tbody>

</tbody>

Any help is highly appreciated.

Thanks and all best//