skipping a filled cell that was input manually by the automated apps script
<p>I'm relatively new to google apps Script coding but I have taken the Javascript learning on Khan and i need some assistance with a problem I'm trying to figure out in google spreadsheets.</p>

<p>The problem is that I am trying to automate information from one sheet to the other like a copy so if an assistance inputs info the manager when he pulls out sheets, it will automatically have the info loaded. I have that part the part I need is if the manager puts in a piece of info I don't want the assistances info to overlap it.</p>

<p>I am pretty sure I need an if statement but not sure how to correctly word it in Apps Script.
This is what I have so far:</p>

<pre><code>    function onOpen(e){
    /*SpreadsheetApp.getUi()*/
    var sheet = SpreadsheetApp.getActiveSpreadsheet();
    var ss = sheet.getSheetByName('names');
    var range = ss.getRange('B2:B100');
    var data = range.getValues();
    var sheet1= SpreadsheetApp.getActive();
    var ds = sheet1.getSheetByName('Sheet1');
    ds.getRange(2,2, data.length, data[0].length).setValues(data);

    var sheet2 = SpreadsheetApp.getActiveSpreadsheet();
    var sss = sheet2.getSheetByName('names');
    var range2 = sss.getRange('C2:C100');
    var data2 = range2.getValues();
    var sheet3= SpreadsheetApp.getActive();
    var ds1 = sheet3.getSheetByName('Sheet1');
    ds1.getRange(2,1, data2.length, data2[0].length).setValues(data2);
</code></pre>