NEED Help ! Scanning Barcode to check against existing database.

Hello Friends, New here and in need of assistance.

I am recently facing a problem where I need to confirm the number of items received against supplier provided document. To make it clear, I have a excel sheet containing 10 barcodes for 10 boxes. I want to program my Excel file in such a way that once I scan a box, it will directly compare it with any of the 10-existing bar code, to check if the barcode match's (then turn that barcode green) or not (turn that barcode red maybe). In case that there are only 8 boxes scanned and 10 barcodes exist in excel file, I want to set up a trigger which will inform me that only 8 boxes were scanned/checked or that 2 barcodes/box are not scanned.

Also can the Trigger send an email or notification ? - I don't know much about this stuff.

Any formulas, VBA, or macros or any other ideas and suggestions are welcomed and much appreciated. Let me know if this makes sense or you need more information.

crosspost: https://www.mrexcel.com/board/thread...eeded.1171562/

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

Take a look at this post, i helped them with scanned item lookup.

https://www.excelforum.com/excel-for...inventory.html

Also if you can provide a sample file others can assist or chime in..
Read the above yellow banner

Can you explain how you are using your attached spreadsheet?

Cause the formula is realtime, so if you scan an item, it can look up and return whether it was found or not, but as soon as you scan the next one, that last item status wont be there.. because its based on what you scanned..

NOW if you have it setup to store the scanned items as you scan them and place them into that "scanned barcode" tab, then you can use that as you are for a status column in your "Master List - Comparision"

If thats how you are planning or currently have it setup, then you can use what you have or maybe use index match on your Master List - Comparision sheet.

I can help, just trying to better understand the file you provided and how you are logically processing the boxes to better help.

So is this correct for each of the sheets?

#1 = Document generated barcodes this is list provided by the supplier?
#2 = Scanned barcode this is your check-in list as you scan the boxes, they are captured and logged here?
#3 = Master List - Comparision this is where you need to identify if any of the items you scanned exist and if so, highlight them?

So an example, you receive your boxes today, you go thru and scan say 12 boxes, as you scan each box, they are logged/stored in the "Scanned Barcode" sheet. Once you are done scanning you flip over to the Master list sheet and review if anything is missing.. BUT how is your master list maintained / updated.. Is it also adding the scanned items to the master so that all you have to do is apply the formula down the column? (all of which can be done with a macro)

In this case #N/A is the returned value for no matches... Do you want it to return something else?

I updated the formula and works now.. take a look at the attached.

No problem, ill look out for the other post/thread