Create button “add & clear”

[Dianiec]

What I am after is to create “add & clear button with macro on my sheet. So I want to add things to “on stock” and then I want this to be added to the “in stock” and by pressing “add & clear “ I want in stock to update and on order to get clear.

 

[Marc L]

According to your attachment a VBA demonstration for starters :​

Sub Demo1()
    With Range("B2", [B1].End(xlDown)).Columns
        .Item(2) = Evaluate(.Item(2).Address & "+" & .Item(3).Address)
        .Item(3).ClearContents
    End With
End Sub

Do you like it ? So thanks to click on bottom right Like !
​