google apps script - Copy every row of Data from one sheet that has a given value in column K to another sheet

Question

I'm working on a Google Spreadsheet the will use a Script to copy every row of Data from one sheet that has "Done In The Past 30 Days" in column K to another sheet.

By "sheet" I mean every tab. Source tab is "Arley" destination tab is currently "ArleysSandbox" Every row has ll columns, A-K. The entire row should be carried over. The number of total rows in the sheet will increase over time. Every time I run the Script, I want it to clear all existing data on "ArleysSandbox" first. Column K, where it says "Done In Past 30 Days" is a formula. I will eventually want to pull from multiple sheets and compile on the Sandbox sheet.

I was using a post from the old forum as a starting point but got stuck due to my lack of knowledge. http://productforums.google.com/forum/#!msg/apps-script/FNGzVkEqZh4/x8WCYtjvpI8J Thanks in advance for any suggestions.

Answer 1

//Find current filter and remove     
var currentFilter = master_sheet.getFilter();
      if ( currentFilter !== null ) {
        master_sheet.getFilter().remove();
      } 
     var master_lr=master_sheet.getLastRow();
     var master_lc=master_sheet.getLastColumn();


//Apply filter here
      master_sheet.getRange(1,1,master_lr,master_lc).createFilter();
      var criteria = SpreadsheetApp.newFilterCriteria().setHiddenValues(['Reject','Approved']).build();
      master_sheet.getFilter().setColumnFilterCriteria(45, criteria);

      master_sheet.getFilter().getRange().copyTo(harmonize_approvers.getRange(1,1,master_lr-1,master_lc), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);