SOLVED

help with creating an inventory management for production purpose

Copper Contributor

Hello!

I work with manufacturing security doors, and to make my life easier I wanted to create an excel chart with a table of materials in the inventory then subtract from them the materials I need for each type of door I am going to make.

For example, let us say I made door1 and it requires X amount of bolts and X amount of welding wires ...etc I want to subtract that from the inventory when I write the door type.

I have not used excel much, but I know the very basic formulas, anyone knows how can I create this, please? 

2 Replies
best response confirmed by KuroMJ (Copper Contributor)
Solution

@KuroMJ 

You cannot subtract a number from the inventory using worksheet formula, rather you have to create a new column showing final levels.

Thank you that was exactly what I needed to finish my sheet!
1 best response

Accepted Solutions
best response confirmed by KuroMJ (Copper Contributor)
Solution

@KuroMJ 

You cannot subtract a number from the inventory using worksheet formula, rather you have to create a new column showing final levels.

View solution in original post