Hi,

I am trying to create a button which when clicked, will subtract the Stock Used, from the Total Stock number cell which is in another worksheet.
E.g. a product is built, and therefore uses x5 M2 screws. When the button is pressed this value of 5 will be subtracted from the Total stock of M2 screws.

Any thoughts?

Thanks, Jonny