Select the range of cells.

F5SpecialBlanksOK

Enter an = sign in the active blank cell then arrow or point to non-blank cell
above.

Hit CTRL + ENTER keys.

This will fill in the blanks with a formula pointing to the cell above.


Gord Dibben MS Excel MVP

On Sat, 1 Dec 2007 07:56:01 -0800, Moz wrote:

I need to know the easiest way to tell excel if the Cells are blank than copy
the cell directy above it, if the cell is not blank go to the next row and
repeat.

RO NO BOOKED. CLOSED. DT TECH. LN SEQ M HT
1883 7-Nov-07 7-Nov-07 S1 61 B 2 OT
ST
1883 7-Nov-07 7-Nov-07 S1 61 C 3 ST