How do I make a specific quantity in excel automatically go down when scanning a corresponding barcode?

LAKE, Joe (ISLAND CITY PRACTICE) 25 Reputation points
2024-01-24T14:21:28.38+00:00

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 !

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,326 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,313 questions
0 comments No comments
{count} vote