Fill in blank cells with line above
 

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.

Fill in blank cells with line above
 

Watch this short video:

http://www.contextures.com/xlVideos01.html#FillBlanks

--
Biff
Microsoft Excel MVP


"gleakos" wrote in message
...
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.

Fill in blank cells with line above
 

Select the column then F5SpecialBlanksOK

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

Hit CTRL + ENTER

CopyPaste SpecialValuesOKEsc


Gord Dibben MS Excel MVP

On Mon, 15 Sep 2008 14:01:01 -0700, gleakos
wrote:

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.

Fill in blank cells with line above
 

Hi Gord Dibben,
Good Work dear

Thanks
===============================
"Gord Dibben" wrote:

Select the column then F5SpecialBlanksOK

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

Hit CTRL + ENTER

CopyPaste SpecialValuesOKEsc


Gord Dibben MS Excel MVP

On Mon, 15 Sep 2008 14:01:01 -0700, gleakos
wrote:

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.

Fill in blank cells with line above
 

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.

"T. Valko" wrote:

Watch this short video:

http://www.contextures.com/xlVideos01.html#FillBlanks

--
Biff
Microsoft Excel MVP


"gleakos" wrote in message
...
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.

Fill in blank cells with line above
 

Thanks.. the CNTRL ENTER is what was missing from the prior reply.. Thanks
again

"Gord Dibben" wrote:

Select the column then F5SpecialBlanksOK

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

Hit CTRL + ENTER

CopyPaste SpecialValuesOKEsc


Gord Dibben MS Excel MVP

On Mon, 15 Sep 2008 14:01:01 -0700, gleakos
wrote:

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.

Fill in blank cells with line above
 

Watch the video again. It is there.

Fat Jack Utah wrote:

Thanks.. the CNTRL ENTER is what was missing from the prior reply.. Thanks
again

"Gord Dibben" wrote:

Select the column then F5SpecialBlanksOK

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

Hit CTRL + ENTER

CopyPaste SpecialValuesOKEsc


Gord Dibben MS Excel MVP

On Mon, 15 Sep 2008 14:01:01 -0700, gleakos
wrote:

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.



--

Dave Peterson

Fill in blank cells with line above
 

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Fat Jack Utah" wrote in message
...
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.

"T. Valko" wrote:

Watch this short video:

http://www.contextures.com/xlVideos01.html#FillBlanks

--
Biff
Microsoft Excel MVP


"gleakos" wrote in message
...
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.