I'm looking for a way to track Vacation Bible School attendance using Excel and a barcode reader. We'll create a database of all the children and their information during registration on the first day. They'll receive a pre-printed barcoded bracelet at registration. We would like to be able to simply scan the barcode at 'Check-in' and Check-out' each day (5 days) to count attendance as well as verify the information of the individual who is picking up the child at 'check-out'. Does anyone have something you're using now or a template that could get me started? My Excel skills are average but I don't have any experience with 'vlookup'.
Thanks!
Bookmarks