With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
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 MIwww.energyefficientbuild.com. Feb 27, 2013 user Joseph Marshall said:(http://productforums.google.com/forum/#!mydiscussions/docs/LeUWuXZlNCc)
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?
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.