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

Home Forums Google Sheets & Forms How do I automatically create tabs with specific custom information? Reply To: How do I automatically create tabs with specific custom information?

#2835
Rob Clarke
Keymaster

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, 7 months ago by Rob Clarke.
Skip to toolbar