Forum Discussion
Help with a changing qty on hand formula
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.
The forum has removed the attachment. 😡
What kind of tablet? Windows, iPad, Android, ...?
It will be an iPad, but the other computers are not Mac's