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

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.

Try this code:

Please Login or Register  to view this content.

HTH,
Maud

Hi safari,

Try this.

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

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.

Originally Posted by bakerman2

@ 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.

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.