// Abhijeet Chopra
// 26 February 2016
// Google Apps Script to make copies of Google Sheet in specified destination folder

function makeCopy() {

// generates the timestamp and stores in variable formattedDate as year-month-date hour-minute-second
var formattedDate = Utilities.formatDate(new Date(), "GMT", "dd-MM-yyyy' 'HH:mm:ss");

// gets the name of the original file and appends the word "copy" followed by the timestamp stored in formattedDate
var name= SpreadsheetApp.getActiveSpreadsheet().getName() + " Copy " + formattedDate;

// gets the destination folder by their ID. REPLACE 1Q9v74DrFaHFz7PkAmqPKpDWB7qbtSRta with your folder's ID that you can get by opening the folder in Google Drive and checking the URL in the browser's address bar
var destination = DriveApp.getFolderById("1Q9v74DrFaHFz7PkAmqPKpDWB7qbtSRta");

// gets the current Google Sheet file
var file= DriveApp.getFileById(SpreadsheetApp.getActiveSpreadsheet().getId())

// makes copy of "file" with "name" at the "destination"
var fileNew = file.makeCopy(name, destination);

var ssNew = SpreadsheetApp.openById(fileNew.getId());
var rng = ssNew.getSheetByName('Лист1').getDataRange();
rng.copyTo(rng, SpreadsheetApp.CopyPasteType.PASTE_VALUES, false)
}