I am using Excel 2016
I am making a material inventory list which will also include the amounts required to produce each of our model types.
.
Column "F" is the current "quantity in stock" of every part in my inventory
Columns H, J, L and N are the amount of that material required to produce each unit type.
On my "asset list" tab I have a completed unit stock list. As each unit is serial numbered I am entering each unit on a separate line. There are columns for each unit type.
I am trying to make so when I enter the number 1 in any of those 4 columns on the "Asset list" that the amount of material required to produce (columns H, J, L and N) will be subtracted from column F (quantity in stock)

EXSPREADSHEET.png
0
LVL 31

Comment

by:Tom Cieslik
Please ask question (not post)  if you need help from our community
0

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month