Scan to Excel

[jcwelch111]

We have several punching machines in a manufacturing facitity that each have several punch units on them. I want to enable operators to scan the punch units and the unit be found in the spreadsheet, be prompted to enter a quantity, and have that data sent to the Excel spreadsheet to populate that cell. I have searched the web some and found the Motorola MT2000 series looks to be just what we need as far as capability and cost (not too much and not too little). The MT2000 has Microsoft .NET framework and MCL Client from what I've read, though I don't have any experience with these. I do have a little experience with writing programs in VBA. How hard would it be to setup this device (or any other you may suggest) to work for this application. I need it to:

1. operator scans the barcode on the unit and the scanner sends that data to the spreadsheet where the corresponding unit ID is located, and the cell for the quantity alongside said ID is ready for population
2. Scan gun prompts operator for quantity, which when entered is sent and populates quantity field in spreadsheet
3. consecutive scans of the same unit will either

a) be summed continuaously in the same cell to keep a "running total", or
b) the next unpopulated cell below will be ready for subsequent quantities to be entered

Below is a rough idea of the spreadsheet layout options.

Tool ID #	Unit Type	# Punches
123456	PU-25	xxxxxxxx

<tbody>
</tbody>

Tool ID #	123456
Unit Type	PU-25
# Punches	xxxxxx
	xxxxxx
	xxxxxx
	xxxxxx
	xxxxxx
	xxxxxx

<tbody>
</tbody>

Any help is greatly appreciated. Thanks in advance!

 

[jcwelch111]

Looks like my tables came from a 1970s word processor. Sorry couldn't figure out how to just copy and paste directly from Excel into the post, nor copy and paste a snipped image either.