Hey, I'm trying to track inventory amounts and I have multiple sheets using different amounts of each ingredient, and I want one production run to update the total inventory amounts.
The trouble is this creates a self referential sequence.
Total - Used Amount (Different values depending on sheet) = New Total - Used amount.....
Keeping in mind this is a long column of ingredients I don't want to manually update each time.
It would be great to have multiple buttons to press to subtract based on which production was run. E.G.
1000 units - 300 units = 700 units then when I run a different production: 700 - 150 = 550 units.
Thanks,
-CVD
The trouble is this creates a self referential sequence.
Total - Used Amount (Different values depending on sheet) = New Total - Used amount.....
Keeping in mind this is a long column of ingredients I don't want to manually update each time.
It would be great to have multiple buttons to press to subtract based on which production was run. E.G.
1000 units - 300 units = 700 units then when I run a different production: 700 - 150 = 550 units.
Thanks,
-CVD