Loop Copy and Paste VBA

[Inglish78]

Hello,

Trying to create a Macro whic would help me copy and paste valuein te empty cells below. It would stop at the next cell with a value and would copy an paste it again till he next cell ... See below for clearer explanation Column A is how it is know. Column B is how the result would be. Thanks for the help !

a	b
123	123
	123
	123
456	456
	456
789	789
	789
	789
	789
	789
101	101
	101
	101

<colgroup><col width="64" style="width: 48pt;" span="2"> <tbody> </tbody>

 

[Joe4]

Welcome to the Board!

It is actually pretty easy to do this without a macro.
See: https://www.extendoffice.com/documents/excel/771-excel-fill-blank-cells-with-value-above.html

If you want a macro, you can just turn on the Macro Recorder, and record yourself performing the manual steps, and you will get the code you need.

 

[Inglish78]

Thanks alot !!

 

[Joe4]

You are welcome!