Hi
I have a spreadsheet displaying jobs ( Runs ) that gets added to on a daily basis.
Each row contains a serial no of a stock item that is linked to another sheet displaying current Stock quantity.
What I’m trying to do is add a checkbox on each row that is linked to a macro that performs a Vlookup on the serial number
And reduces the current stock quantity for that product by 1 when the checkbox is pressed.
Is this possible and if so is there any example I can download please.
Bookmarks