Stock Control

Hi Guys

I am trying to create a button that when clicked will adjust the stock taken out of the stock list in that day.

On Sheet 1 will be a list of what has been taken out of stock in that day.

On sheet 2 will be the main stock list which will be adjusted when the button is clicked.

As there are several products it will need to recognise which product it is and remove it from the correct total in the stock list.


I really hope you can help as ive been trying to resolve this for a while now with various if statemtns

Thanks in advance.

Ed