Monday, January 16, 2012

yogi_Create AddressBook With Each Row Sorted Alphabetically By Surname In Separate Sheets

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
Eric1983 said:
Hello, 
I'm very new to this and would really appreciate some help. 
As the title suggests, I'm trying to make an address book with data submitted via this form: https://docs.google.com/spreadsheet/viewform?formkey=dGgwYjFRenpzdWU5eUNtNmNtX29ZZEE6MQ
This is where I need your help! I want each row to be ordered alphabetically according to the surname into separate sheets.[The surname is in column C].
Examples: 
The row below should appear in the 'J' sheet (for Johnson) 
Forename          Surname            Phone number         Email                                     Note


   

Eric         Johnson       12345678        eric@johnson.com    This should go in sheet J
The row below should appear in the 'T' sheet (for Thompson) 




Forename          Surname            Phone number         Email                                      Note


  

Tony         Thompson      99999999        tony@thompson.com   This should go in sheet T





How can I do this? 
Thanks very much in advance! 
--------------------------------
following is a solution to the problem ... the Form_Data in columns A through E is populated from Form submissions and column F is a computed column.
Then I created a sheet for each alphabet from A to Z and then I pull the data in each sheet from the Form_Data sheet and order it in ascending order.


No comments:

Post a Comment