function copyPhoneList() { var hasFirstName = false; var ss = SpreadsheetApp.getActiveSpreadsheet(); var data = ss.getRangeByName("masterPhoneListData").getValues(); var range = ss.getRangeByName("masterPhoneListData"); var numColumns = range.getLastColumn() - range.getColumn() + 1; var phoneList = new Array(); for (i=0; i y ? 1 : 0; } else { var x = a[3].toLowerCase(), y = b[3].toLowerCase(); return x < y ? -1 : x > y ? 1 : 0; } }); // All done, put the data into place target.getRange(2, 1, phoneList.length, phoneList[0].length).setValues(phoneList); }