Copy Paste formla

[Xavif31]

Dear all, 

I really hope you will be able to help me on this one, It could save me lots of time. 

Basically, lets say you have the formula =A1 in cell "B3" and you want to copy this cell in cell "D3" ; the result will be =C1 

I want when copy paste from B3 to D3 that the letter stay the same but the number change by +1....as a result having =A2

If I use =$A1 the result will be $A1.

Is anyone knows the formula I should use to lock the letter but change the number to +1 when copy paste ?

Thank you very much for you help. I hope It is clear enough :)

Good evening. 

[#2]

Try the suggested formula in the attached picture.

You should copy it from cell B3 to D3 and F3.
________________________
Michael Micky) Avidan
ISRAEL

[#3]

Thank you very much for taking the time to answer to me. Unfortunately I am not as good in excel and I have tried several times but it does not seems to work. It might be from my side though. :(

Have a great evenning

Xavier