How do I make a specific quantity in excel automatically go down when scanning a corresponding barcode?
I am trying to create a stock management system for many different items. I have created a barcode for each item, a barcode scanner and have an excel sheet with the items and their quantities. I want to make it so that when I can scan an items barcode, its corresponding quantity in the excel sheet is reduced by 1, to show it has been removed. I have looked at command buttons and VBA but have no clue what to do, any help would be appreciated. thank you !