Code would certainly be one way. Another:
- link to the spreadsheet from Access
- in a spreadsheet column (not the linked one) drag to fill a numeric list from 6000 to 7025.
- paste append (Access Ribbon) that column into the table you'll use for the data (would contain the same fields as your spreadsheet columns). You should get a numeric list
- create a query to update the table with the linked spreadsheet column data
- the table fields (name, etc) get updated with the spreadsheet data for each number that matches in each. Table numbers that don't exist in the spreadsheet will remain blank. As I read the post, you want a complete ascending list from one starting to one ending number but have the name data for those numbers that are in your source data.
Last edited by Micron; 12-13-2019 at 10:53 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.