Help with barcodes and excel

[grant965]

Hi all, basically after setting up barcodes to help me manage stock better.
Parts are stored in a big box, so ideally put a barcode on the box and scan to tell me what is in there and allow me to update if I sell something.
Been googling all night and nothing is making any sense to me.
Thanks, Grant
____________________
Ex bikes: 05 Suzuki En 125, '98 Yamaha Thundercat, '08 Honda cbr125, '05 Kawasaki z750, '03 Triumph Daytona 600, '91 Kawasaki ex250, '03 Hyosung Comet 125
Current Bike: '02 Suzuki TL1000R

[el_oso]

what's your question?
____________________
Duke 390
Previous: '05 XR125L | '96 XJ600S Diversion |'05 Suzuki GSXR1000 | '05 Honda CBR125-R | '97 YZF 600R Thundercat | '11 Honda CBR250
Car: Jeep Wrangler 4.0L

[grant965]

[Doovy]

Method 2 here: https://www.wikihow.com/Create-a-Barcode
____________________
Yamaha RXS 100 > Honda CD 250 > Honda Hornet 600 > Honda CBR 600RR > Yamaha RXS 100 > Kawasaki ZX6R J2 > Yamaha FZ1

[map]

[Andy_Pagin]

Open a terminal session

yum install or apt-get barcode

then for example:

barcode -b 12345678 -u mm -g +100+100 -o tempfile.pcl

lp tempfile.pcl
____________________
They're coming to take me away, ho-ho, hee-hee, ha-haaa, hey-hey,
the men in white coats are coming to take me away.
Yamaha Vity -> YBR125 -> FZS600 Fazer -> FZ1-S Fazer

[serlant]

at work we use.

https://www.idautomation.com/free-barcode-products/code39-font/
____________________
04 CBR1000RR, 1995 Husqvarna TE410, 1998 VTR1000(Sold), 1990 XJ600(sold), 1996 KH125(dead and sold)

[t121anf]

So have you sorted the backend out?

Barcodes are just graphical versions of characters, so you need something, form or similar to lookup the value in the barcode to find the relevant contents.

Or have I missed the point and you plan to do something different?

(ps if you have the excel backend sorted, upload a copy I'd be interested to)

[t121anf]