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,

Sheet link: https://docs.google.com/spreadsheet/ccc?key=0AgNzRu4Jyu2cdEwwSDM2V3Jrdkg3Ti1IYmRBQVpWSWc&usp=sharing

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. 

------------------------------------