Copy Paste : Loop Until

[RAKESH230583]

Dear all,

Wanted to understand the Loop Until in Copy & Paste.

Example:
Data are available in Sheet1. Column A
There are numbers available in various cells - Some are filled in and some are blank.
Requirement is to copy 1st filled in cell in column A and then paste it below in all blank cells till it finds next filled in cell.

Lets say in below example : 123456 should be pasted in A2 & A3, Value ABCDEF to be pasted in 5,6,7 & 8, Value 4567 to be pasted in 11 and the stop as there is not filled cell after that.
A
1 Value 123456
2
3
4 Value ABCDEF
5
6
7
8
9 Value XXXXX
10 Value 4567
11
12value 123
13

 

[Joe4]

There is an easy way to do that without loops (which are inherently slower), and it can be done manually or via VBA.
See: https://www.extendoffice.com/documents/excel/771-excel-fill-blank-cells-with-value-above.html
To do it via VBA, just turn on the Macro Recorder while you record yourself performing the manual steps.