Stock In/Out Sheet - Help to make more efficient

[JDobbsy1987]

Hi All,

I was hoping someone could help either re-design the way this sheet works or help make it more efficient.
I have attached the spreadsheet in question (this sheet contains dummy info but the sheet itself is in the exact format as the one i use, all i have done is replace the data in it).

Basically the 2 main tabs in question are 'Stock' and 'Change Log'

Stock Tab
This sheet is meant to keep a record of all stock, as stock comes in/goes out it gets updated on the sheet however the issue i have is every row has a macro for in and a macro for out therefore each product has 2 macros (i'm sure you can understand how time consuming it is recording 2 macros every time new products are added).

The way it work is you type the quantity (in the 'In' or 'Out' cell) near the top of the sheet and then click the macro button (Green for In and Red for Out) and it recalculates the QTY in column F

Change Log Tab
This is meant to keep a record of every change made on the sheet, it records the time, product and the quantity in/out.
This is updated as part of the macros mentioned above (green/red buttons)


Can anyone advise the best way to achieve this without creating a ton of macros all the time?
If we have to start a new sheet all over again but meaning it would be a lot more streamlined then i am happy to do so

Regards,
Jamie