Macro Button HELP

[SirTLAW]

Hi all,

First time posting.

I am trying to get a button to add incoming stock into a stock on hand column as well as a usage button to subtract stock from the same column.

I have attached an image with the spreadsheet as well as the code for the macro (which I have borrowed from one of the forum posts here).

What I am trying to achieve is for column "G" to add to column "F", and column "H" to subtract. I also want to exclude the rows above the red line so they aren't impacted when a button is pressed.

Currently the add button is working, I just need to exclude the rows, but the subtract button is not.

Any help would be greatly appreciated.

Thanks,

[/URL]

[/IMG]

 

[Fluff]

Hi & welcome to MrExcel.
To exclude the top rows change

For i= [COLOR=#ff0000]7[/COLOR] to

What is not working with the 2nd code?

 

[SirTLAW]

Thank you so much!

Unsure of what was wrong with the second code, last night it was asking me to debug the code, but all is working now.

Appreciate the help

 

[Fluff]

Glad it's working & thanks for the feedback