Adding & Increasing Inventory Quantity Automatically When Entering Stock Number
Posted on 2013-02-02
I have an Excel workbook created in Excel 2010. There are 2 worksheets - Invoice and Inventory.
The Invoice worksheet has 7 columns::
The Inventory worksheet has 3 columns:
B= Item Description
On the Invoice worksheet, the Stock Number is entered by scanning a barcode into the first cell (A17). Then, formulas pull the Description and Price from the Inventory worksheet.
I would like to be able to have the initial quantity (1) entered automatically into the Invoice worksheet in the appropriate cell (first cell would be C17). Then, whenever the same barcode is scanned, instead of adding another line item, it would increase the count of the first scanned identical barcode.
Any help would be greatly appreciated. I've attached the file for reference.