Add relative formula to next column

Hi all,

The recorder couldn't help me, so hopefully you can:

I want to make a macro that drags my formula* over to the next cell (in the same row) which doesn't contain the formula, but has an absolute value in it. As a result the absolute value will be overwritten. The absolute value in the cell next to the changed cell, should be unchanged until I run the macro again.

* I would like this formula be "relative" so when you drag it the formule "=A23" will be "=B23" in the next cell etc.
** I added a simplified example.

*Solved thanks to Mehmet*