Find / search serials no. And auto fill or check .

[hakoworld]

Hello all , I am very amateur in excel ,
We have excel count sheet of our inventory ,nearly a sum of 20k unique serial numbers of parts with barcode on them when my staff does stock count they scan and find each part and fill a colour in the cell to check , that involves 2 person and a lot of keystrokes in each part,

So I want something in which we can just keep scanning those serial number and the cell gets checked or colour filled auto and move to next one .

* All unique serial number are in a row
* after full scan want to filter the unchecked ones .


thanks