Help: Inventory Control

Hello Everyone,

I am new here and is trying to pick up some macros knowledge so that I can learn to use excel to do inventory control.
I would like to have at least 3 sheets: Inventory, Submit Ins (A page with a "submit inventory in" button to add inventory to the inventory sheet), Submit Outs (A page with a "submit inventory out" button to deduct inventory to the inventory sheet). And ideally, if possible to save the inventory in and inventory out to a database sheet or separate worksheet upon pressing the submit button for record.

Pls find attached example of what I have in mind and would appreciate if some directions, pointers or examples can be given to me so that I can know where to start.

Thanks in advance !

mystock.xlsx

Hi FDibbins,

Thanks for the welcome.
I have added some dummy data, and was searching online for more information for the whole day. Finally managed to get part of the "submit inventory in" button working Upon pressing the button, the data will be copied to the inventory_list sheet (reflect current stock status).

Will still need lots of help as I am beginner at vba programming and my head is starting to swell with all the codes.
I will continue to work on it to see if I can expand it so that it will copy to a database with the submit date captured for record as well.

And of course, still need to get the "submit inventory out" button working to deduct from the current inventory_list sheet.
The internal reference code and the mfg date has to match for the deduction.

Any help will be deeply appreciated.

mystock_1.1.xlsm