in my workbook I have a sheet for product and a sheet for receipts data base (that would be a growing data base of all items sold)
I have each of my inventory items number and use that number to auto populate my receipts with description and price.
I would like to search the data base for any instance of an item # showing in column A then pull the data of that rows column D (qty sold) for each time that item # shows and keep a running total on the product sheet column E as a running total.
I also have a maco that copies the data from my receipts tab to the data base tab and then prints and clears the receipts tab
I have each of my inventory items number and use that number to auto populate my receipts with description and price.
I would like to search the data base for any instance of an item # showing in column A then pull the data of that rows column D (qty sold) for each time that item # shows and keep a running total on the product sheet column E as a running total.
I also have a maco that copies the data from my receipts tab to the data base tab and then prints and clears the receipts tab