Get value of the adjacent cell if current cell is empty in VBA
<p>Is there a way to copy the value of the adjacent cell if the current cell is empty using <strong>VBA</strong>?</p>

<p>Example here: </p>

<p>If I loop through the cells of column A and a cell is empty, copy the value of adjacent cell of column B to that empty cell in column A.</p>

<p><a href="https://i.stack.imgur.com/hvCRe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hvCRe.png" alt="enter image description here"></a></p>

<p>This should be the report I generate: </p>

<p><a href="https://i.stack.imgur.com/1Zy3o.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1Zy3o.png" alt="enter image description here"></a></p>