Google Apps Script – copy and paste filtered cells value – part 040.

This tutorial is about copy-paste filtered cells values.
You need to create a spreadsheet named CustomSheet with two sheets named: SheetInput and Target.
In the SheetInput add this data for each column A,B, C, D, E, F:

A $1 30% AA Criteria
B $1 30% AA AA
C $1 30% CC

The filter cell name Criteria is on row 1 and column F and AA is on filter Criteria value from row 1 and column F.
Use main menu ToolsScript editor to create a script and rename it: CustomSheet.
In this script use this source code, you will see all comments tells you how this works:

The result for filter value AA is this:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.