you want to:
- create a duplicate of the active sheet
- name the duplicate with todays date
- put the date in cell A1
- hide the original sheet
here is solution for 1,2,3, and 4
First create an Apps Script, that will contain the following 4 functions:- create a custom menu to easily access and run the scripts
- create a custom function to get todays date into a cell
- duplicate a source sheet that is a Protected Sheet (then hide the source sheet)
- duplicate an unprotected source sheet that has Protected Ranges (then hide the source sheet)
rename the Custom Menu to your liking
change the GMT-0 to the timezone of your liking
save the apps script before continuing.
next, in order for you to have the date (sheet name) in cell A1, the source sheet must have the same structure, and therefore in cell A1 of the source sheet you can put this formula:
this uses the second function in the above code
next, reload the G-Sheet, this will prompt the first function to create a Custom Menu in the header section.
now, to copy the sheet, make sure it is active (visible) in the browser, and...- to copy a Protected Sheet, you simply click on the Custom Menu, and click "Duplicate Protected Sheet"
- to copy a sheet that has Protected Ranges, but is NOT a Protected Sheet, just click "Duplicate Sheet with Protected Range"
Bookmarks