I have a problem with importing data to excel and making the data go to specific loacations.
Im using a wedge scanner plugged directly into my PC at work. Any data that I scan with the scanner will import directly into excel VIA Column A row 1, the a2, a3 ect.
Let me explain what I'm doing and what I need to do.
What I'm doing::
I'm currently haveing to manually type in the following data to excel and then sort for reporting: Column A :Tech Number,Column B :System,Column C: Good/Bad, If bad then error. and so on. I will do this up to 5000 times in a week. This process is very time consuming and very outdated.
What I need to be doing::
I've made a series of barcodes that will represent: Tech Number, System, Good/Bad ect. I want to scan the barcode and have the data import directly to excel in specific columns for sorting. This would save:Paper, Time, Fingers
When I scan a barcode the data only populates to Column A and down A1,A2 ext.
Is there a way to make the data go to specific columns and when I go to a techs number again the data will populate to the next row and start over again?
I know this can be done, but how?
Thanks for your time,
Video Tutorials / Excel Dashboards Reports