HOW DO I ALPHABETIZE MULTIPLE PAGES OF A SPREADSHEET?

[JAY]

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?

 

[woalmoore]

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

 

[woalmoore]

Ah. I found it at
http://www.officekb.com/Uwe/Forum.aspx/excel-functions/81468/ALPHABETIZE-WORKSHEETS-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 Before:=Sheets(i)
End If
Next j
Next i
End Sub

Then you just run it as a macro.

 

[Gord Dibben]

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