Forum Discussion

Amber001's avatar
Amber001
Copper Contributor
May 06, 2022

Traceability help

I am very new to using Excel and I am trying to find out if there is any way to use excel for lot traceability.

I need to be able to use a barcode scanner to scan a barcode and pull the data off the barcode (lot/serial numbers, expiry dates and maybe even supplier Info). I am not sure if this is possible but any and all help would be greatly apricated. 

 

Thanks,

Amber

1 Reply

  • mathetes's avatar
    mathetes
    Gold Contributor

    Amber001 

     

    My sense is that scanning a barcode into Excel is the easy part. A quick Google search would cause one to think that. 

    The bigger issue is the whole process design...spreadsheet design being part of that, but possibly a small part.

    I think if I were in your shoes, I'd be starting with a vendor of barcode scanning devices. They may well have a solution waiting for you.

Resources