The .bigCommit() method of cDataSet will commit the contents of that dataset, normally back to the source sheet. However, bigcommit can also write to a different sheet. This behavior allows us make a copy of the values in a worksheet very simply.
Google Apps Script
You want to learn Google Apps Script?
Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, available All formats are available now from O'Reilly,Amazon and all good bookshops. You can also read a preview on O'Reilly.
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Get Started Snippets >