I AM TRYING TO MAKE A RATHER LARGE LIST OF CLIENTS, AND I WOULD LIKE TO FILE
THEM ALPHABETICALLY, BUT I AM ONLY GETTING THE FIRST SHEET TO ALPHABETIZE.
HOW DO I GET MULTIPLE PAGES TO ALL BE IN ORDER?

I know this can be done using VBA in Excel but I don't have the code in front
of me at the time...

"JAY" wrote:

I AM TRYING TO MAKE A RATHER LARGE LIST OF CLIENTS, AND I WOULD LIKE TO FILE
THEM ALPHABETICALLY, BUT I AM ONLY GETTING THE FIRST SHEET TO ALPHABETIZE.
HOW DO I GET MULTIPLE PAGES TO ALL BE IN ORDER?

Ah. I found it at
http://www.officekb.com/Uwe/Forum.as...-AUTOMATICALLY

Sub ArrangeSheetsInOrder()
Dim iCount As Integer
Application.ScreenUpdating = False
iCount = Sheets.Count
For i = 1 To iCount - 1
For j = i + 1 To iCount
If Sheets(j).Name < Sheets(i).Name Then
Sheets(j).Move Befo=Sheets(i)
End If
Next j
Next i
End Sub

Then you just run it as a macro.


"JAY" wrote:

I AM TRYING TO MAKE A RATHER LARGE LIST OF CLIENTS, AND I WOULD LIKE TO FILE
THEM ALPHABETICALLY, BUT I AM ONLY GETTING THE FIRST SHEET TO ALPHABETIZE.
HOW DO I GET MULTIPLE PAGES TO ALL BE IN ORDER?

In your mind, what is the difference between a "sheet" and a "page"?

Which version of Excel?

In versions earlier than 2007 you can have up to 65536 clients on a worksheet.

Those you would sort by name column.

If 2007 version you have more than one million rows to a worksheet.


Gord Dibben MS Excel MVP


On Tue, 20 May 2008 07:58:01 -0700, JAY wrote:

I AM TRYING TO MAKE A RATHER LARGE LIST OF CLIENTS, AND I WOULD LIKE TO FILE
THEM ALPHABETICALLY, BUT I AM ONLY GETTING THE FIRST SHEET TO ALPHABETIZE.
HOW DO I GET MULTIPLE PAGES TO ALL BE IN ORDER?