Inventory management - Matching and sorting barcode scanned with existing spreadsheet info

[QTS18]

Hello,

In an effort to ease my monthly inventory of approx 200 serialized items, I would like to match, sort and identify potentially missing barcode scanned items with my existing spreadsheet. I've have the barcode in a column in my spreadsheet. When I scan in the barcode of the items into a new column, I would like to save time by not trying to go in order of the spreadsheet. Not going in order poses an inventory reconciliation hassle because I am not able to determine what might be still unscanned. What formula or macro can I employ to sort matched items comparing what I think I have with what I scan?

I hope this example shows what I am trying to do. Ideally I would hide the scanned inventory column as the reconciled column is what I need to see.

spreadsheet data...................scanned inventory.................. inventory reconciliation
xyz123..................................yui345...................................xyz123
qwe234.................................jhg456.................................--blank-- (qwe234 not found during inventory)
poi987..................................xyz123................................... poi987
jhg456..................................poi987....................................jhg456
yui345 not recorded................ -----......................................yui345

Can you follow what I am after? Thank you!

QTS