Wednesday, February 27, 2013

yogi_Create A Sister Sheet yogi_Sheet1 To Automatically And Dynamically Order The Data In Sheet1 By Specified Column


                                          Google Spreadsheet   Post  #1055
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 27, 2013
user Joseph Marshall said:(http://productforums.google.com/forum/#!mydiscussions/docs/LeUWuXZlNCc)

Auto Sorting
I'm trying to figure out how to auto sort the information that is imputed into the attached spreadsheet via a Google Form. I need it to be sorted by station code (column C) in alphabetical order. I can do it manually but auto sorting would save me time as I have the information pulled into another spreadsheet utilizing the =importrange function and would like to only reference that spreadsheet without having to go and manually sort new submissions. Is there a simple formula to use for this function to work? 
Attachments (1)
Safety Alert 02-13.xlsx
24 KB   View   Download
---
Yogi,


In the sheet all information is populated by a Google Form on a daily basis. In sheet1 I need all submission to be automatically sorted by "station code" (column C) in alphabetical order. I currently must go into each spreadsheet and manually sort the information or my Master Database, =importrange function will not reflect up to date sorted information. Overall, I just need all new submissions to be automatically sorted in sheet1 by "station code" (column C) in alphabetical order. 
------------------------------------