Bar Code Scanning

[Smileycam]

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.

[smileycam]

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