Automatically Updating Inventory

[dblizzle99]

Hello,

I am trying to set up a way to automatically update inventory numbers as production gets complete, and if anyone can help me that would be wonderful.

I'll create a basic example for this request. Lets say I have "1000" in cell A1 for the number of aluminum parts I have in stock, and cells A3:C8 is my production chart, as shown below:

1000
Part Number	Aluminum Pcs Needed	Part Built?
Part 1	1	TRUE
Part 2	2	TRUE
Part 3	3	TRUE
Part 4	4	FALSE
Part 5	5	FALSE

My question is, is there a way to formulate an equation that automatically update my inventory number in Cell A1 as my parts are being built, or as the cells C4:C8 become TRUE?

Also, is this still possible if my inventory tracker (Cell A1) is on a different sheet than my production tracker (Cell A3:C8 in this example)?


Thanks for any help!!

 

[Saba Sabaratnam]

You could set up two worksheets as shown below.

Enter part name (part 1) in A2 and the following formula in B2 in STOCKS AVILABLE worksheet.

=SUMIFS(PRODUCTION!B:B,PRODUCTION!C:C,TRUE, PRODUCTION!A:A,'STOCKS AVAILABLE'!A2)

Kind regards

Saba