@Tedinoz 1) Before Copy A data check value on same data just update Bcolum before copy and Past i want to check if same value ist exists in Acolum . if the same value exists want to update the bcolum value in same row. other weis add data in new row... Have try the getA1Notation i have try this but its now work its effect on all cell i want just limit the cell's

function onEdit(){
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("entry");
//get data of C4:I4
var range = sheet.getRange(4, 3, 1, 7);
if (range.getA1Notation()){
    CopyRow();
  }
}