Help with stock control sheet
I am looking for a bit of help with a macro I am thinking of creating.
Basically I am working with 2 sheets.
Sheet4 is the master data sheet.
Sheet5 is the calculation results sheet.
This idea is I use Sheet5 to find out the stock that I need to make a product.
Then in the next column in Sheet5 I calculate the stock quantity left.
My problem is I need to deduct the quantity required from the stock quantity in sheet4.
To do this I assume the best way would be to put a button on sheet 5 and assign a macro to it so every time the button is clicked the macro does the rest.
I need to alter the stock value for the corresponding item in sheet4.
So say for the screw in sheet5 the stock value which is obtained via the VLOOKUP (in cell D3) needs to be reduced by the qty 8 (in cell A3).
So at the end of the day when I click in the button the stock value for the screw in sheet4 decreases by 8 it that makes any sense to you.
Basically I should end up with the red values in sheet4 when I click the button once.
I am OK with excel functions but am just beginning with macros.
Sorry if I haven't made myself clear.