Excel Barcodes substract or add number

[thebest07111]

Hello,

Curently I have this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Item[/TD]
[TD]Stock[/TD]
[TD]Barcode ADD[/TD]
[TD]BARCODE SUBSTRACT[/TD]
[/TR]
[TR]
[TD]Samsung Galaxy TAB s3[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Datalogic PBT930[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.

 

[tyija1995]

How exactly are you scanning the barcodes? Would you double click the cell with the barcode to add/subtract it?

 

[thebest07111]

How exactly are you scanning the barcodes? Would you double click the cell with the barcode to add/subtract it?

Hi,

I am scanning it using a barcode scanner that is connectted to the pc

 

[brucef2112]

Take a look at this thread Counting Inventory with Barcode Scanner it is related to take inventory with bar code reader adding to the inventory count with each scan.
This may Give some direction on how to implement your reduction of inventory need.