I’m trying to pull numbers down to zero using multiple cells. So if I have 50 in cell 1 and 50 in cell 2, how do I get excel to pull the 50 in cell 1 down to 0 first before starting to pull the 50 from cell 2
Thank you for that! So if I have 10,000lbs product and I want to split them into 5,000lb /cell because the first 5,000 lbs of product has an earlier expiration date therefore needs to be used up first from inventory but still need to keep track of total inventory. So I’m hoping to pull the 5,000 lbs in cell 1 down to 0 before it starts pulling the 5,000 lbs from cell 2 but always keeping my current inventory visible. Hope this messes sense!