Forum Discussion
Help with a changing qty on hand formula
This could easily lead to mistakes without a way to correct them, since you'd have no history of changes.
I'd use a separate row for each change.
I completely understand what you are saying, however, they just want the 3 without adding more rows.
That would require VBA code, so it'll work on the desktop version of Excel for Windows and Mac only.
Users will have to allow macros, and entering a number in the Add or Subtract cell will disable Undo.
See the attached demo workbook.
Right-click the sheet tab and select View Code to inspect the VBA code.
Thank you. I do not see an attached demo. I did have another thought, do you think if I could talk them into getting rid of the 2 columns beside then qty on hand column, that a pivot table would work? They want to use a tablet in the warehouse to be able to add in and take out stock.
