Fill in blank cells with line above

  • Thread starter Thread starter gleakos
  • Start date Start date
G

gleakos

I need to fill in the blank cells with the information from the cell above
until the next cell is not null. For example:
Column A
Bill
blank
blank
Bob
I need the blanks to read as Bill. Is there a function or something I can
use.
 
Select the column then F5>Special>Blanks>OK

Type an = sign in active blank cell then point or arrow up to cell above.

Hit CTRL + ENTER

Copy>Paste Special>Values>OK>Esc


Gord Dibben MS Excel MVP
 
I did this, but must be missing something.. It kept blanks highlighted blue
but only copied to the cell below.. it did not fill all blanks with the data
above as shown in video.
 
try this idea from a posting of mine today.

Sub copydn()
mc = 2 'column B
For i = 1 To cells(rows.count,mc).end(xlup).row
If Cells(i + 1, mc) = "" Then
Cells(i + 1, mc) = Cells(i, mc)
End If
Next i
End Sub
 
Back
Top