Hi there Kimberly. No that wasn’t a typo – the first part of the function needs to check to see if the ‘Barcode’ exists in column D of the PickList. I would hope this to be unique within the column.
Surely with your amendment it will check to see if the ‘Qty Picked’ exists in column G of the PickList? That’s most unlikely to be unique.
Peter
|