Make a filtered copy of a worksheet

How to use cDataSet.bigCommit() to create a copy of the values in a sheet, and filter the results

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.

VBA

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.

About brucemcp 225 Articles
I am a Google Developer Expert and decided to investigate Google Apps Script in my spare time. The more I investigated the more content I created so this site is extremely rich. Now, in 2019, a lot of things have disappeared or don’t work anymore due to Google having retired some stuff. I am however leaving things as is and where I came across some deprecated stuff, I have indicated it. I decided to write a book about it and to also create videos to teach developers who want to learn Google Apps Script. If you find the material contained in this site useful, you can support me by buying my books and or videos.