Match then Time Stamp

  • 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?

  • Re: Match then Time Stamp


    Call this one solved. When I took the IF section and pasted it into a section of the macro containing another IF routine, it seemed to work fine. Thanks alot Gollem!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!