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                  
Eric1983 said:
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:
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].
The row below should appear in the 'J' sheet (for Johnson) 
Forename          Surname            Phone number         Email                                     Note


Eric         Johnson       12345678    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   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.