Barcode to Excel

The scanner decodes the barcode and feeds text string into the computer in a similar way a keyboard would have done it.

Excel can then can then get the corresponding data record from lookup tables.

The rest is just simple data manipulation and number crunching

Hand held barcode scanners have the keyboard wedge option.

In most cases they are equipped with a USB connection and when you scan they send the scanned content to the active application through the keyboard channel.

In excel it would behave like you enter the data + ENTER.

Of coarse you can fine tune the behavior.

As I stated in your other post for the same query, this will need to be programmed in VBA(Visual Basic for Applications). You can't "lock-on" to a work order without some sort of logical programming to check if the barcode has already been scanned. On the same note, how will Excel know what work order is what? How will it determine how long it should take to complete? How will it determine cost? - Cost of labor, materials, down-time, damages or losses, employee breaks... All of these values need to be factored into the equation. That is, if you really want to automate the process.

Human error, or just plain user-data manipulation can occur if you do not use programming to control the data in the Excel sheet.

Otherwise, just let your workers type in their information themselves. Have a column as an index to employee # (W1, W2, W3, etc...). The next column could be work order #, then time start, then time finish, and finally quantity produced. Even in this situation you will need formulas in the cells to calculate all results. And for anyone to help with this they will need the information listed in my first paragraph to create the necessary formula(s).

I don't know if anyone would write such a program for you free of charge. It would take almost a days work to get a majority of it set up, then a few days to work out any issues. And if there is a lack of communication, even longer.

I accept payments through paypal.

Thank you to all. My company has more than 100 people, therefore, an automate system is necessary to transfer all information to a central database. Acticzone, you have just give me more information than I previously thought.