Hi all,

We are trying to use our hand held barcode scanner and Excel to give us
a result when someone has submitted their work at the University. We
have 308 names of students.

These are the steps we have done:

1. Scan ID to x cell.
2. If x cell = one of these IDs then have submitted, else not
submitted.
3. Clear x cell and wait for next scan.

A sample has been attached.

Regards,

Shiraz.


+-------------------------------------------------------------------+
|Filename: barcode scanner sample.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4915 |
+-------------------------------------------------------------------+

--
Smileycam
------------------------------------------------------------------------
Smileycam's Profile: http://www.excelforum.com/member.php...o&userid=22366
View this thread: http://www.excelforum.com/showthread...hreadid=553885

Does anyone have an answer for this?

Smileycam wrote:
Hi all,

We are trying to use our hand held barcode scanner and Excel to give us
a result when someone has submitted their work at the University. We
have 308 names of students.

These are the steps we have done:

1. Scan ID to x cell.
2. If x cell = one of these IDs then have submitted, else not
submitted.
3. Clear x cell and wait for next scan.

A sample has been attached.

Regards,

Shiraz.


+-------------------------------------------------------------------+
|Filename: barcode scanner sample.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4915 |
+-------------------------------------------------------------------+

--
Smileycam
------------------------------------------------------------------------
Smileycam's Profile: http://www.excelforum.com/member.php...o&userid=22366
View this thread: http://www.excelforum.com/showthread...hreadid=553885