Hi All,

I'm trying to create a button that will remove stock.

We have a column 'E' that lists our current stock levels of professional fireworks in our stores. When we pick a firework show we enter how many units we would like to remove from stock in column 'I' This then gives us a total in money of how much stock we are using.

What I want to be able to then do is click a button that will take the stock level for say E9 = 8 units and then minus how many we are taking out I9 but this button would replicate this for the whole column rather than having to remove each item individualy.

Then a simple button to clear all the entries in column I.

Any help?