I want to hold values in excel after deleting the cell data that was factoring it.
For example: I pull 1 tube from p5, I input that into the cell, it does the calculations then after deleting the 1 tube pulled it completely removes that value from the data it was altering and its causing a hiccup for me at the moment as if it never happened.
Tubing in stock (P1) Tubing Available to Pull (p5) Tubing Pulled from P5
6/17/2019
5 1 0
Prior to subtracting 1 from p5
Tubing in stock (P1) Tubing Available to Pull (p5) Tubing Pulled from P5
6/17/2019
6 0 1
After Subtracting 1 from p5 and adding it to p1
Tubing in stock (P1) Tubing Available to Pull (p5) Tubing Pulled from P5
6/17/2019
5 1 0
After I delete the 1 because I want to use this sheet again in the future.
This is for work, been stuck on it for sometime.
Bookmarks