Attendance sheet, using barcode scanner

Hi,

I am trying to create a spreadsheet to use at a company event, to track attendance.

All of the attendees have an ID badge, with a barcode, that has their unique code.

I would like to be able to scan the attendees badges and have the letter "Y" inserted into the "Attended Date" row which corresponds with their name.

I don't know if I've explained this properly, so if any more information is required please let me know.

I am attaching a sample file, however this is not set in stone, so if you need to move everything down a few rows, or make any other changes, that's fine!

Thanks, in advance, for any advice offered.

Edit to add: My profile says I am running Excel 2010, but I am running Office 365. Thought I should update the post to reflect this, while I try and find how to change it in the profile.

Welcome to the forum.

Your barcode scanner provider should be able to provide the information you need to get your scanner talking with Excel.

I found this about the Orca Barcode Scanner: https://orcascan.com/guides/how-to-s...excel-59fd67f9

Once your scanner is linked to Excel, then we can help.