Inventory Management: ADD and REMOVE buttons

[petg]

Hey Everyone !

I have a request and would appreciate it if you could help me out ! So I have an excel sheet which manages my inventory. So far it allows me to add items and remove items.

For instance if you click on the manage inventory button and choose to Add/Update records, if something exists it brings up the description and gives you a quantity. You can change the quantity (If you take out of inventory). So if you change the quantity to something less than it already was and press the button it will get a message telling you that you are subtracting whatever the difference is. So if the amount was 500 and you can change it to 400, you get a message box saying you are subtracting 100 and when you click update, the quantity it will change to 400 and on the second sheet you will see a log of the Description, quantity removed, the date and time it was removed. It also logs the amount that is added, So if the amount was 400 and I change it to 500, it gives me a message saying you are Adding 100 and when you click the update, the quantity will change to 500 and on the second sheet you will see a log of the Description, quantity added, the date and time it was added.

I have added two new buttons to the Add/Update functions, named ADD(+) and REMOVE(-) (I have included a screenshot of it also found on my excel sheet). So my request is that I want to have a function added to those buttons, so when I scan an item that is already in the inventory and want to add to it I can just type in the number of items I want to add, lets say I want to add 36 to the inventory, I can just type 36 in the text box and click the ADD(+) button which will then also log it in the second sheet. Same goes with the REMOVE(-) button. So lets say I have 500 in the inventory and I want to remove 40, I can just type 40 in the text box and click REMOVE(-) and it will remove 40 from the inventory and also log it in the second sheet as -40.
Addandsubtract.PNGInventoryManagementExcel_REMOVING.xlsm

Thanks in advance !

[LeoTaxi]

Hello Petg,

see if this is the way you want.


Kind regards
Leo

[petg]

Leo, you're the man ! Thanks a lot