Q:

Copy a column with a formula to another tab

I've got a column in one tab that is a concatenate of two other columns that needs to be moved to a new tab.  As you might expect, the formulas are copied rather than the values.  
I saw [this from @Serge] Copy every row of Data from one sheet that has a given value in column K to another sheet which is where I think I need to go, but wanted to see what I was missing (because I usually do :)  )
var sourceTab = ss.getSheetByName("Sheet1");
var xportTab = ss.getSheetByName("Sheet2");
sourceTab.getRange("P1:P").copyTo(xportTab.getRange("A1"));  // new description

Any other tricks someone can suggest?

Joe  

A:

If I understood you correctly, you want to copy just the values, right?
You can do it like this:
function copyExample() {
  var ss = SpreadsheetApp.getActive();
  var source = ss.getSheetByName('Sheet1');
  var values = source.getRange(1,16,source.getLastRow(),1).getValues();
  ss.getSheetByName('Sheet2').getRange(1,1,values.length,1).setValues(values);
}

