Controlled Data Entry - Bar Code reader to complete 6 columns on a row - then return to the next row

[texmansru47]

Sorry for the long title, but it gets confused with some of the other YOUTUBE and responses I have gotten. I am creating a CSV file to collect serial numbers and asset tags from hardware like monitors and docking stations. HOWEVER I only have 6 columns where data collection will happen. I want to see if in excel (without VBS) is there a means to scan in all 6 serial numbers and assets tags and have the cursor move to the next column (that is working fine)... but once it hits the 6th column the cursor will start at column 1 on the next row... Is that feasible in native Excel?

 

[awoohaw]

Can you clarify what you mean by doing something in "Native Excel".
Do you want the Bar Code Reader to create data directly into an excel file?
If so, what is the CSV file you mention in the second sentence for? CSV files usually auto wrap and move to the next row.
But, you could also bring your CSV data into power query. Maybe some examples of good results expectations and the bad of what you're getting now would help?

 

[texmansru47]

Can you clarify what you mean by doing something in "Native Excel".
Do you want the Bar Code Reader to create data directly into an excel file?
If so, what is the CSV file you mention in the second sentence for? CSV files usually auto wrap and move to the next row.
But, you could also bring your CSV data into power query. Maybe some examples of good results expectations and the bad of what you're getting now would help?

Yes that is true but I only have 6 fields to collect data... and I cannot seems to block or limit the document to those 6 fields.