RECEIVING SHEET & INVENTORY SHEET
I have 2 sheets. One receiving that product is received daily and one inventory sheet.
I would like to have the receiving sheet update the inventory sheet as new product arrives.
Since we get the same product on different days, I'm not sure how to account for the product and quantity to transfer to the inventory sheet and not require multipule rows.