title: Select blank cells after a used cell and copy data
body: <p>I have a problem regarding this:</p>
  
  <p><a href="https://i.stack.imgur.com/na166.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/na166.png" alt="enter image description here"></a></p>
  
  <p>I need to make the blank cells' value equal to the value of the used cell before them. My desired outcome is this:</p>
  
  <p><a href="https://i.stack.imgur.com/C8jX4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/C8jX4.png" alt="enter image description here"></a></p>
  
  <p>You can observe that the blank cells' value depends on the value of the used cell before them. Is there any way to achieve this using macro? Thanks.</p>