help me with using bar code on existing excel

winas

New Member
Joined
Jan 6, 2024
Messages
1
Office Version
  1. 2021
  2. 2019
  3. 2016
Platform
  1. Windows
Hello all,

I have this excel with Ref codes (bar code numbers) and I need to use the bar code that I bought (ZKTECO Omni Direction Barcode Scanner) if someone want to buy any product by just scanning the bar code of the product with subtracting the Quantity of the products without scanning all the products and entering theme manually as they are already exist on the excel.

Thank you
BL.xls
ABCDEFGHIJKLMNOPQ
9RefDesignationQtéPrixR% Total TTC
101EV21N Enveloppe kraft N°21 1000,12012,00
112417803pochette Perforée 80 Mic Boost BO-PP80 280,000160,00
1236111242750630Chemise Bull 60G 200F Spring Colors 160,00060,00
134789117Chemise à Rabat En Cartonne Brillant 258,000200,00
145SUR12Chemise à Serre Feuillle 104,00040,00
1566971092845531Pistolet a Colle deli A50061 160,00060,00
1676971092845548Pistolet a Colle deli A50161 175,00075,00
178940518Laminating Pouch Film A4 216*303 mm 125mic 1135,000135,00
189502006Paquet de papier Carbone Bleu Copytech 165,00065,00
19106971588623919Couverture Transparent A4 OBO BINDING COVER 175,00075,00
2011120041Bloc Calque A4 93GM 50F 135,00035,00
2112821156COUVERTURE CHROMOLUX 250G 165,00065,00
22134549526608667Calculatrice Casio FX-82ES Plus 2125,000250,00
23148411574058465Calculatrice Milan Cod.159906LK 3110,000330,00
2415191069CALCULATRICE CATIGA CD-2653 170,00070,00
25164971850032274Calculatrice Casio GX-12B 1170,000170,00
2617SB/Stylo Bic Divers Coulleurs 2001,200240,00
27188034049919346Machine Etiqueteuse 1 linge boost ref BO2616-20 N/RT 1450,000450,00
28196281073425059Colle Stick 35g Fantastick 1018,000180,00
2920494911Cachet Trodat 11 Printy 4911 38*14mm 275,000150,00
3021494912Cachet Trodat 12 Printy 4912 47*18mm 285,000170,00
3122464630Cachet Trodat 30 Printy 4630 30mm 2125,000250,00
BonLivraisonPrint
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How can I use barcode on existing Excel !
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top