Hi all,
I'm newbie in VBA and so I hope in some help.
I have an inventory list that I need to update each time something is in or out. I have to scan a long list so I bought a barcode scanner.
Using the find function that excel has I'm able to found the product by EAN code then manually I enter the quantity in the pcs column.
Now even if I searched in many forums I wasn't able to adapt some solution to my case, this is the reason way I open this tread.
My aim is to create a cell that get the scanned EAN code as input an pass it to a VBA macro. The macro will allow me to scan the column B and add 1 into pcs column each time I scan the some EAN, after that the cell has to be clear automatically to be ready for the next scan. With the some procedure I would like to create a 2nd cell that allows me to subtract 1 when a pcs lefts.
In both cases I would like to have a warning if the value is found or not.
I attach the excel sheet I have
Thank you in advance for any help/suggestion
Bookmarks