• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Create button “add & clear”


New Member
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.


  • packaging.xlsx
    13.1 KB · Views: 5
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)
    End With
End Sub
Do you like it ? So thanks to click on bottom right Like !