Hi guys need your help please.......

Every month I get a report in excel with desktop serial numbers to perform a stock take. I usually print it out and tick them off as in stock or not, as easy as it sounds it take me ages as we have hundreds of stock.

I have a barcode scanner that i use to import all new stock, what i would like to do is:
Scan the desktops that are in stock and have it display "yes" for in stock.

So the spreadsheet would be column "A" has the serial numbers and I would like for column "B" to display the result “yes”.

Is this possible?

Any help would be appreciated.