In Make a copy of a worksheet we looked at how to use the .bigCommit() method of
cDataSet to copy a table from one worksheet to another. This method is also capable of filtering - meaning only copying rows where a particular column value equals some value. Here's
how to copy only rows where the city is London.
Google Apps Script
In this example, I am going to assume now that you are using cDataSet from an external library rather than from a local copy. You will see that we are using the functions from the Mcpher namespace.
Take a look at One Liners for more tips like this. In the meantime why not join our forum,follow the blog or follow me on twitter to ensure you get updates when they are available.
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 >