Scan barcode in excel to sign children in and scan again to sign out.

[mosajad]

Hi, I am totally new to excel. I run a holiday club for children. We are soon going to issue PVC cards with a barcode on it to children. we have a excel database with all the children details including barcode and id number. what I am now needing to setup a new worksheet which I can scan the barcode in A2 and find the childs name in B2 and have a time IN stamp in C2. when at the end of the day we will scan their barcodes as they leave and D2 we want another time stamp. the children will not be signed out in order as they signed in the morning so will need a way of excel automatically locating the child and updating the time stamps. Please help, I am very new to this and this club we run is on a voluntarily basis and can not afford £1000s to but the professional system. Thanks.

 

[hiker95]

mosajad,

Welcome to the MrExcel forum.

What version of Excel and Windows are you using?


See the below link, and, begin at reply #14:

Private Sub Worksheet_Change(ByVal Target As Range)
' hiker95, 02/04/2013
http://www.mrexcel.com/forum/excel-questions/672492-scan-barcode-excel-date-time-stamp-out.html


Is the above something that may work for you?