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