Case Sign Out Template macro 1.xlsmCase Sign Out Template macro 1.xlsm

Hi
i am trying to develop a sign out sheet for students using a barcode of their student number.
I have used a previous post to get this far.
I can scan into B2, it then compares the value with the sheet. What I am struggling with is that i want it to insert a time stamp in the relevant column on the correct row.
I then want the scan cell value to be deleted.

Many thanks in advance.

Les