Dynamic stock sheet

Hi Excel Wizards.

Hope you can help me here

I have 2 sheets.
(See attachment)

Sheet 1:
Stock overview with total amount the stock on each items.

Sheet 2:
Insert date, choose an item from a list, then either add og remove a specific quantity of that item.


My mission here is to update the stock value on the overview sheet (sheet1), on that item that has been chosen on sheet2.

Example: "MHA" have taken 2 "Keyboard DK" the 6th March. The total stock count for "Keyboard DK" should then adjust with -2 on sheet1.

Any suggestions would be much appreciated.
Thanks in advance

Hi HusHans

Welcome to the forum...
Try this in sheet2 Module...
Copy code...
Right Click on Sheets("Add - Remove Items")
View code ... paste

Please Login or Register  to view this content.

Glad I could help...Tx for rep +