barcode search help

[GaryHinton]

I have 2 sheets in excel. 1 sheet is printed out for employee to sign and have an assigned barcode to there name. I want to scan that barcode and have it search for a match on the other sheet and highlight it. I am not using any barcode software just a usb scan gun. it will scan to the excel sheet but cant get it to search for a match

 

[Logit]

.
You need a macro activated by the barcode scan.

Two basic functions for the search macro are "VLOOKUP" and "Range.Interior.Color ="

There have been numerous posts on this FORUM and other Excel Forums covering the use of handheld scan guns.