Transfer cell value to another cell by clicking on a button in Google Spreadsheet

Question

I want a user to be able to click on a button and have the value of one cell go into another cell.

How can I do this?

Answer 1

Adapt this script to transfer value of A1 to B1:

function transfer() {
    var s = SpreadsheetApp.getActiveSheet();
    r = s.getRange("A1");
    // copyValuesToRange method will copy value in A1 to B1(range of B1 - 2,2,1,1)
    r.copyValuesToRange(s,2,2,1,1);
    r.clearContent();
}

Assign this script to your button.