Stock Levels, Minus a list of values at the click of a button

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?

Wow, where do you guys learn this stuff!

Thanks for the speedy reply. I'll give it a go.

Edit: already replied to

This is fantastic!

I've changed the

Dim wsSrc As Worksheet: Set wsSrc = Sheets("Sheet1")

To reflect the worksheet, but how would I get the macro to run on multiple worksheets?

Thanks, I hope your off out somewhere nice!

I was thinking I could list the worksheets rather than get it to do it to all of them worksheet1!worksheet2!worksheet4 etc?

Hi Guys.

Just getting back to this.

So I have the following but I don't know where to put the extra lines to make it work for all workbooks.

Formula:

Please Login or Register  to view this content.

Yes please.