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.