How does the data show up when you scan it? Does the barcode automatically show up in the active cell?

If this is the case, then create a sheet for orders and a sheet for sales. When you order items, ensure the "Order" sheet is active. Same for sales.

Then have a master sheet that looks-up the orders less the sales. This will be your active inventory listing.

**Attach some data that you've created with the cheap barcode scanner and someone will be able to write a macro or assist better.