alphabetizing a database with formuals after adding new data

[veganfury]

I'm working on creating a workbook for a teacher friend that will have
grade tracking program, an attendance program, and then a final progra
that creates personalized reports listing grade and attendance.
would like to set it up so that you can add new students and update i
to be alphabetical but keep the proper grades for each student.

I curently have it set up where you type students names into the grad
worksheet and these names are automaticaly transfered to the attendanc
worksheet as well as added to a dropdown list for the report program.
Due to formatting, formulas, locked cells, protections or something
cannot alphabetize the list of names from the grade worksheet unless
unprotect the worksheet but if I unprotect the worksheet formulas t
calculate grades can be altered or deleted.

I've attached a *.zip file with the *.xls file I am working on so tha
people can look at it and make changes, the password is "nadja".

Suggestions?

Thanks in advance to all the helpful people out here!

And, oh yes I have no clue how to do most things with Excel. I hav
only entered data into it until this weekend when I started thi
project and have been reading the help files quite a bit but due to th
fact that I am not familiar with a lot of the vocabulary and that I a
brand new at this I'm not sure how to solve this.

Matt
(e-mail address removed)

 

[Myrna Larson]

Set up a macro to unprotect the sheet, sort it, then protect it again. Add a
button to call the Sort routine.