Hello World!

My VBA/Macro skills being very poor, I am lost facing the problem I have to solve!

I need to setup a student class attendance system, using a USB RFID reader, and I was thinking about Excel, I found some stuff on the web, but nothinf fulfilling my needs....

What I need :

Student swipe their cards when walking in the classroom, a timestamp is created in a column "punch in", if they swipe card again after a certain delay (let's say 5 minutes), another stamp is added in a new column "punch out".

In the excel file, a worksheet containing students names/class/RFID tag number where the code/macro will do a lookup to attach student name to rfid_ID.

Not sure my explanations are clear....but your help will be appreciated!

Thanks for your support!