Barcode scanning database

[mbb670]

Hi there!
I need a lot of help:
I need to be able to scan a brcode into a single cell (one that is frozen at the top of the spreadsheet), have excel find that serial number in a list of serial numbers, enter a check mark into the adjcent cell and a date and time stamp adjcent to that.

Please if anyone can help me, i'm very new to excel so I still don't know many of the functions or how they work (but I do have a basic understanding of some) (I am running Excel 2007)
and please any help at all would be amazing!


this is a example of what I was hoping the table would look like (with a row above to scan the barcodes in):



[TABLE="width: 500"]
<TBODY>[TR]
[TD]Room Type
[/TD]
[TD]Room Number
[/TD]
[TD]Serial Number
[/TD]
[TD]Check
[/TD]
[TD]Date/time
[/TD]
[/TR]
[TR]
[TD]Patient
[/TD]
[TD]746
[/TD]
[TD]070101-074600
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Patient
[/TD]
[TD]747
[/TD]
[TD]070101-074700
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Office
[/TD]
[TD]748
[/TD]
[TD]070101-074800
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Patient
[/TD]
[TD]750
[/TD]
[TD]070101-075000
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

 

[mole999]

search for barcode on here, there are more than a few examples, read them and see what limits / can be achieved, then pick what you want and explain where you need the help. ode won't help until you have a workable solution to grab the scanned values