Auto fill blank cells with data in a cell above

Asssuming your student name is in column A, In a blank column starting in row 2

=IF(ISBLANK(A2),A1,A2)

and drag down.

Then copy that column over to column A with Paste Special>Values.

Does that work for you?

ChemistB

Many thanks for your reply but this does not solve my problem detailed underneath.

Student Name
a
Need to Fill with "a"
Need to Fill with "a"
Need to Fill with "a"
Need to Fill with "a"
Need to Fill with "a"
Need to Fill with "a"
b
Need to Fill with "b"
Need to Fill with "b"
Need to Fill with "b"
Need to Fill with "b"
Need to Fill with "b"
Need to Fill with "b"
c
Need to Fill with "c"
Need to Fill with "c"
Need to Fill with "c"
Need to Fill with "c"
Need to Fill with "c"
Need to Fill with "c"
d
Need to Fill with "d"
Need to Fill with "d"
Need to Fill with "d"
Need to Fill with "d"
Need to Fill with "d"
Need to Fill with "d"
Need to Fill with "d"
Regards


Alan

Sorted.... Many thanks this has been a great help my problem is now resolved

Thanks

Alan