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 !

[TABLE="width: 96"]
<colgroup><col width="64" style="width: 48pt;" span="2"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"]a[/TD]
[TD="width: 64, bgcolor: transparent"]b[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]123[/TD]
[TD="bgcolor: transparent"]123[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]123[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]123[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]456[/TD]
[TD="bgcolor: transparent"]456[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]456[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]789[/TD]
[TD="bgcolor: transparent"]789[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]789[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]789[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]789[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]789[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]101[/TD]
[TD="bgcolor: transparent"]101[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]101[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]101[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[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!