Friday, February 17, 2017

yogi_Pull Every Nth Column From Source In Another Sheet Dynamically As Columns Are Added Or Deleted In Source

Google Spreadsheet   Post  #2115
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Feb-17-2017
question by GeoTechGuy:!topic/docs/e7-heDOyIr4;context-place=forum/docs
Filter view dynamically

I have to following formula that works great at the moment but, as I add columns to the sheet I don't want to have to edit the formula each time. Is there a way (maybe via script) to filter view every 6th column? Below is the script that works but I need a way to have complete the same function without having to edit it all the time as columns are added. For example, when I add columns GS-GY, I need a script that will recognize GY as the 6th column and add it to the filter. 


Thanks all.