Tuesday, January 6, 2015

yogi_Pull Data From Ark1 Into 'yogi_TESTING' Pushing The Data With Status 'Processed' To The Bottom Of The Sheet

             Google Spreadsheet   Post  #1877
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-06-2015
post by  Michael Iversen:
https://productforums.google.com/forum/#!mydiscussions/docs/QJEG3mw-Zb4
Auto Sort after Date
Hi Team, 

have a Sheet where we are adding and processing data in.

would like to get the sheet to sort the date everyday at midnight, depending on the "K" if it is "Processed" it should be moved to the buttom of the sheet automatically

the sheet have the data there needs to be moved with in  A2 to N2

and goes to 1000 in total atm. 
-----------------------------------------------------------------------------------------------------------------------------------------------
in the proposed solution presentedd below the data is pulled form 'Ark1' and sorted in such a way that the rows with the status of 'Processed' is pushed all the way to the bottom of the sheet