Traceability help

%3CLINGO-SUB%20id%3D%22lingo-sub-3334226%22%20slang%3D%22en-US%22%3ETraceability%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3334226%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20very%20new%20to%20using%20Excel%20and%20I%20am%20trying%20to%20find%20out%20if%20there%20is%20any%20way%20to%20use%20excel%20for%20lot%20traceability.%3C%2FP%3E%3CP%3EI%20need%20to%20be%20able%20to%20use%20a%20barcode%20scanner%20to%20scan%20a%20barcode%20and%20pull%20the%20data%20off%20the%20barcode%20(lot%2Fserial%20numbers%2C%20expiry%20dates%20and%20maybe%20even%20supplier%20Info).%20I%20am%20not%20sure%20if%20this%20is%20possible%20but%20any%20and%20all%20help%20would%20be%20greatly%20apricated.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EAmber%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3334226%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3335545%22%20slang%3D%22en-US%22%3ERe%3A%20Traceability%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3335545%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1383147%22%20target%3D%22_blank%22%3E%40Amber001%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20sense%20is%20that%20scanning%20a%20barcode%20into%20Excel%20is%20the%20easy%20part.%20A%20quick%20Google%20search%20would%20cause%20one%20to%20think%20that.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_0-1651870518533.png%22%20style%3D%22width%3A%20594px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369908i1125C66C090766EE%2Fimage-dimensions%2F594x230%3Fv%3Dv2%22%20width%3D%22594%22%20height%3D%22230%22%20role%3D%22button%22%20title%3D%22mathetes_0-1651870518533.png%22%20alt%3D%22mathetes_0-1651870518533.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20bigger%20issue%20is%20the%20whole%20process%20design...spreadsheet%20design%20being%20part%20of%20that%2C%20but%20possibly%20a%20small%20part.%3C%2FP%3E%3CP%3EI%20think%20if%20I%20were%20in%20your%20shoes%2C%20I'd%20be%20starting%20with%20a%20vendor%20of%20barcode%20scanning%20devices.%20They%20may%20well%20have%20a%20solution%20waiting%20for%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

@Amber001 

 

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

mathetes_0-1651870518533.png

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.