RP - Thanks, this is a help because I can now see how the code would go
if I decide to take that route.

Pete - I think you might be right and I believe one of my colleagues
who has been helping develop the workbook took this approach with his
trialing.

I have this code already in place which inserts today's date at the top
of the column -

Public Sub Date_Today()
With ActiveCell
.Value = Date
.NumberFormat = "dd-mmm-yy"
End With
ActiveCell.Offset(1, 0).Select
End Sub

Could this be extended so that it put a tick or letter or symbol next
to each pupil?

The code would need to look and see if there is a number in column A
(each pupil is numbered) and put a tick in the corresponding cell. It
would continue down the list until there was a blank in column A.

Can anyone achieve this?

Thanks,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=495852