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?
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 tabsourceDataRange = 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 7 years, 1 month ago by Rob Clarke.