Copy filled cells in a column to empty cells below - until the next filled cell occures - and so on

[TROWKRO]

Hi Could anyone help me with the following? I would like to create a VBA that copies the first found value in Column A to the empty cells below - until the next filled cell in Column A occures. Then this value is copied to the empty cells below etc. - until there are no more entries in column B.

Thanks in advance.

Column A	Column B
10	2
empty - should be filled with '10'	6
45	78
empty - should be filled with '45'	12
empty - should be filled with '45'	34
empty - should be filled with '45'	55
empty - should be filled with '45'	99
34	0
empty - should be filled with '34'	11
empty - should be filled with '34'	4
empty - should be filled with '34'	7
empty - should be filled with '34'	3
empty - should be filled with '34'	0
empty - should be filled with '34'	90

<tbody>
</tbody>

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...-below-until-next-filled-cell-occures-so.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.