Reply To: How do I automatically create tabs with specific custom information?

[Rob Clarke]

Hi again @fbellinger16vanasch-school-nz,

I just got two responses to my query in the G+ community – they look promising:

function copyTab() {
var ss, sourceSheet, sourceData, sourceDataRange, newSheetTab;

ss = SpreadsheetApp.getActiveSpreadsheet();//Get active spreadsheet

sourceSheet = ss.getSheetByName(“Sheet1”);//Get the source sheet tab
newSheetTab = ss.insertSheet(“New Sheet”);//Create a new sheet tab

sourceDataRange = sourceSheet.getDataRange();

sourceDataRange.copyTo(newSheetTab.getRange(1, 1));//Copies the data from a range of
//cells to another range of cells. By default both the values and formatting are copied

}

…and another to check Alice Keeler’s RosterTab2 – plus, here is the step by step tutorial for this particular script which I think is what you are after 😉

Let me know how you go – plus I hope the arm/hand is okay.

Rob

• This reply was modified 6 years, 10 months ago by Rob Clarke.