Storing Values From Sheet1 To Sheet2

  • I have two columns in Sheet1 which are temporary input fields, which will be cleared after I click a 'store' button... I know the code to clear the fields, but I don't know the code to transfer a total from one sheet to another whilst adding on to the value that is already on sheet2.


    Lets say the fields say (A1) - 100 and (B1) - 25.


    When I click 'store' I want to add those two field values to the historical total in Sheet 2 (a1 & b1).


    Could someone tell me the formula to do so?