One | Pace Spreadsheet Better !!hot!!

function syncWithPublicSheet() var public = SpreadsheetApp.openById("PUBLIC_SHEET_ID"); var private = SpreadsheetApp.openById("PRIVATE_SHEET_ID"); var publicData = public.getSheetByName("Arcs").getDataRange().getValues(); private.getSheetByName("Arcs").clear(); private.getSheetByName("Arcs").getRange(1,1,publicData.length,publicData[0].length).setValues(publicData);

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later. One Pace Spreadsheet BETTER

That night, he didn't sleep. He opened a blank document. No macros. No nested IF statements. No VLOOKUPs referencing a hidden tab called "DO_NOT_TOUCH." function syncWithPublicSheet() var public = SpreadsheetApp

Exactly what he told it to.