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 in the first sheet.
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.
So my request is now that it logs the quantity removed I want it to also log the amount that is added. So if the amount was 400 and I change it to 500, I want it to give 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.
Thanks in advance !
InventoryManagementExcelfile.xlsm
Bookmarks