Search Range for NonBlank Cells, Fill Down only one cell below NOT all Blank cells belof

[safari20WDG]

Hi All,

I'm stuck. Read several posts on filling all blanks in between non-blanks, but I just want to fill the first blank cell below the non-blank before
searching out the next nonblank. I can't do a simple Link formula because I sort and filter a lot, which mixes up the cell above reference.

Please Login or Register  to view this content.

Appreciate the help. Looking forward to see how simple it might actually be.

[Maudibe]

Try this code:

Please Login or Register  to view this content.

HTH,
Maud

[quekbc]

Hi safari,

Try this.

Please Login or Register  to view this content.

[safari20WDG]

Thanks, Maud. I think I follow this. But instead of installing the blank with text "Filled", I wanted to have the blank cell populated with the contents of the cell above.

Thanks also to quekbc, but that code fills in all blanks between - want just the one cell down filled with the contents of cell above.

[Maudibe]

Please Login or Register  to view this content.

[quekbc]

Okay, I get it. So... if you have 3 blank cells from say C1300:C1310, you only want C1300 to be filled and leave C1301:C1310 to be blank? Is that right?

If that's the case then - small tweak here

Please Login or Register  to view this content.

[bakerman2]

@ quekbc

After 1148 posts you should know to post your code with Code Tags around.
Please amend your last post. TY

[quekbc]

@ quekbc

After 1148 posts you should know to surround code with Code Tags.
Please amend your last post. TY

Ouch... that hurts bakerman2. After 5 years in the forum I'm sure you have at least once posted a message without the code tags and rectify it immediately after. In any case, I'm done. Cheers.

[safari20WDG]

Now we're talking. Thanks, Maude.

Okay, I get it. So... if you have 3 blank cells from say C1300:C1310, you only want C1300 to be filled and leave C1301:C1310 to be blank? Is that right?

Not quite, but close. If there were 3 blank cells from C1300:C1310, they system would have copied C1299 and pasted to C1300, than advanced down skipping past C1301:C1310 because they're blank.

Still appreciate both your help. Love it when I see a new and different way of writing. Thank you.

[bakerman2]

How about this ?

Please Login or Register  to view this content.