jbaldassarre
New Member
- Joined
- Sep 13, 2022
- Messages
- 1
- Office Version
- 365
- 2021
- Platform
- Windows
Hello,
I am sure this is something that can be done but my mind is drawing a blank on how I can do this.
I have a two sheet spreadsheet. On one sheet, we use a barcode reader to identify an ID card number and a timestamp for when the ID card was scanned. Simple.
On the second sheet, we have the data for the individual that matches the ID number.
How can I get the pertinent data from their Last Name, First Name etc into the first spreadsheet once the card has been scanned?
I am sure this is something that can be done but my mind is drawing a blank on how I can do this.
I have a two sheet spreadsheet. On one sheet, we use a barcode reader to identify an ID card number and a timestamp for when the ID card was scanned. Simple.
On the second sheet, we have the data for the individual that matches the ID number.
How can I get the pertinent data from their Last Name, First Name etc into the first spreadsheet once the card has been scanned?