Excel Workbook Reference
Posted on 2012-04-13
I need to scan some barcodes.
I need a list of total barcodes in sheet1, and then when I scan them into sheet2, I need to ensure there are no duplicates in sheet 2(if there are a msg box would be great). I am assuming I would need coding for this, can anyone help out?
I already have the bardcodes to "match" in sheet 1, I just need a reference in sheet 2 saying "look in sheet 1, make sure there is a match, then look in sheet 2 and make sure this number doesnt appear anywhere"