VBA code to copy exact formula but adding one change

[liiamra]

Dear All!
I hope that I get the assistant required.

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 instance: 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.



I have attached an example of what I exactly need. I did it manually, and if I do it for the whole data set it will take ages regardless of the errors that might result from the manual work. Any help is highly appreciated.

Thanks and all best//
Ali