Fill cells with the contents of the next non-blank cell above

[ellison]

Hi, trying to (repeatedly!) fill cells with the contents of the next non-blank cell above.
And we can see how to go through the standard procedure of highlighting the cells, then: Home / Find & Select / Go To Special / Fill in Blanks / Enter Formula / Hit Ctrl Enter
But between fat fingers and having to repeat this over and over, we are seeing some mistakes.
Is there some code or another way of doing this to give us the result we are trying to aim at?

Hopefully these 2 mini sheets show V1 with blanks cells throughout. And V2 showing how we would like it to end up...

fill-from-next-none-blank-cell-above-question.xlsm
	A	B
1	Row	V1
2	2
3	3	1
4	4	fill
5	5
6	6
7	7	in
8	8
9	9
10	10
11	11
12	12	the
13	13	blanks
14	14
15	15
Sheet1

fill-from-next-none-blank-cell-above-question.xlsm
	A	B
1	Row	V2 with blanks filled in
2	2
3	3	1
4	4	fill
5	5	fill
6	6	fill
7	7	in
8	8	in
9	9	in
10	10	in
11	11	in
12	12	the
13	13	blanks
14	14	blanks
15	15	blanks
Sheet2

Thanks for taking a look!

 

[kevin9999]

This is a different question and you should start a new thread.

 

[Peter_SSs]

This is a different question and you should start a new thread.

In fact, that had already been done ..
Duplicate to: How To Fill Blanks

@jamiguel77
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this older thread so please continue in the linked thread.