Link to home
Create AccountLog in
Avatar of Dier Eluom
Dier Eluom

asked on

Create an excel spreadsheet that reads and inserts data

I want to create an excel sheet that reads Names, Ages  and Clubs off a CSV file and inserts them into another sheet next to an RFID number that has been read off a wrist band with a chip in it.
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Please attach example files.

You can import using  Get External Data in the Data Tab of the Ribbon. Use the Text option.
Avatar of Dier Eluom
Dier Eluom

ASKER

I am scanning an RFID wristband using a reader.  The ID number is recorded automatically in an open spreadsheet.  Once the ID number is scanned in the other columns populate with Name, Age ,Club and points.  So I would need to have a workbook with two sheets - allPlayers and ID.   When the ID is recorded the data is automatically pulled from the ALL-Players sheet and populates the ID sheet.
ASKER CERTIFIED SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thank you.  That was exactly what I needed.
Pleased to help