Hello,
I have two separate sheets that need to be connected. One is an inventory sheet of all raw materials in stock, and the other is a record of all raw materials delivered.
If we receive a delivery of a type of raw material we already have some in stock of, the quantity of that material is simply updated in the inventory sheet. Each row of the inventory sheet contains each raw material we have. To calculate the quantity of that raw material, the quantity cell uses SUMIFS to look through the delivery sheet to find all the rows with that material's name and some the quantities delivered.
However, we may also receive a shipment of a new material that we did not previously have in stock. Therefore, new material does not yet exist in the inventory sheet. This new material will be entered as usual into the delivery sheet.
How do I
1. recognize that this new material name does not exist in the inventory sheet
2.Then, automatically fill in a new row in the inventory sheet using the information of this material from the delivery sheet.
Please let me know if I can clarify anything. Thanks!