LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 788
Default Alphabetize when data changes

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to alphabetize data from separate cells within same row marketingchickie Excel Worksheet Functions 2 November 30th 09 09:55 PM
is there a program i can use to automaticaly alphabetize data rbailey0884 Excel Discussion (Misc queries) 0 June 24th 09 05:21 PM
alphabetize Ahsen New Users to Excel 1 February 1st 07 04:13 AM
alphabetize EC Excel Discussion (Misc queries) 4 December 13th 06 12:36 AM
How do I alphabetize data in the field list? jmw Excel Discussion (Misc queries) 1 July 13th 06 10:43 PM


All times are GMT +1. The time now is 11:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"