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

All the data is stored in this spreadsheet: https://docs.google.com/spreadsheet/pub?hl=en_GB&hl=en_GB&key=0AjjyusyX606edGgwYjFRenpzdWU5eUNtNmNtX29ZZEE&output=html

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.