Hello,
I have a workbook that has a number of pages. Each page contains a list of
roughly 30 students. I want to have one master sheet that lists all the
students in alphabetical order. Right now I have a formula that pulls the
names from each name slot on each of the pages as well as a number showing
which page. However, I would like it to automatically realphabetize whenever
I add an additional name. I dont know if this is possible, but it would
really help because the teacher I am doing it for is fairly illiterate when
it comes to computers and would probably mess it up.