Looking for a means of keeping an updated "automatic" inventory

ZMinior

Is there a formula I could use that would:

1.) When "Complete?" is checked on the right side…

2.) Subtract the "Units Requested" with respect to "Lot" from the left side and populate the "Remaining Inventory"

The idea is to have a master inventory sheet that will show remaining inventories while having a secondary sheet that will serve as a place for all inventory requests using a form.