Hi. I have a table with a column A containing filled cells and empty cells. I would like to create a VBA that copies the filled cells to the empty cells below, and when a new cell value occures, this will be copied to the next cells below etc. until there are no more values in column B. Would this be possible?
Thanks at advance.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "10"[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "25"[/TD]
[TD]45[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "25"[/TD]
[TD]67[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "25"[/TD]
[TD]77[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "25"[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "30"[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "30"[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "30"[/TD]
[TD]45[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "30"[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "30"[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "30"[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
Thanks at advance.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "10"[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "25"[/TD]
[TD]45[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "25"[/TD]
[TD]67[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "25"[/TD]
[TD]77[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "25"[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "30"[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "30"[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "30"[/TD]
[TD]45[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "30"[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "30"[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]empty - should be filled with "30"[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]