I have 2 barcode scanners on opposite ends of a conveyor. Barcode data from reader 1 inputs the data in Column A. Reader 2 will be inputting its data into J2. When J2 has data inputed, I would like to match that data to column A. On the row where the match is found, I would like to transfer a "Yes" to column H and a time/date stamp in column I. Once this has occurred, clear the data from J2. I will have a minimum of 20 seconds between the scans on the second reader.
Is this possible?