<div>
Please attach example files.<br />
<br />
You can import using &nbsp;Get External Data in the Data Tab of the Ribbon. Use the Text option.
</div>


<div>
I am scanning an RFID wristband using a reader. &nbsp;The ID number is recorded automatically in an open spreadsheet. &nbsp;Once the ID number is scanned in the other columns populate with Name, Age ,Club and points. &nbsp;So I would need to have a workbook with two sheets - allPlayers and ID. &nbsp; When the ID is recorded the data is automatically pulled from the ALL-Players sheet and populates the ID sheet.
</div>


VLOOKUP.xlsx

<div>
Thank you. &nbsp;That was exactly what I needed.
</div>


<div>
<div class="content wysiwyg-content">
I want to create an excel sheet that reads Names, Ages &nbsp;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.
</div>
</div>


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.

Create an excel spreadsheet that reads and inserts data

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.