Excel Barcodes substract or add number

thebest07111

New Member
Joined
Aug 22, 2014
Messages
12
Hello,

Curently I have this:

ItemStockBarcode ADDBARCODE SUBSTRACT
Samsung Galaxy TAB s35
Datalogic PBT9302

<tbody>
</tbody>

So I have created barcodes and inserted them in the barcode add and barcode substract field.
Each barcode has a different value.

What I want to do is for example when I scan Barcode ADD for Datalogic PBT930 the 2 becomes a 3 and when scanning again 3 becomes 4 etc.
Same for substract for example scanning Barcode Substract of galaxy TAB s3 the 5 becomes a 4

In every line of my table wich reprisendts a product a barcode an ADD en substract barcode is displayed.
 
Last edited:

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

tyija1995

Well-known Member
Joined
Feb 26, 2019
Messages
766
Office Version
365
Platform
Windows
How exactly are you scanning the barcodes? Would you double click the cell with the barcode to add/subtract it?
 

Watch MrExcel Video

Forum statistics

Threads
1,102,453
Messages
5,486,993
Members
407,575
Latest member
calc

This Week's Hot Topics

Top