Forum Discussion
Excel - Organize Tab/Sheets Alphabetically
What is the fastest way to organize the Tabs in Alpha order? Rather than click and drag to where it goes. Thanks.
Theoretically you could automate it with a VBA code, but I'm not sure if your version of Office can work with macros. As far as I've learned here, certainly not with Excel for web.
If it does, here's the code.
Sub SheetsSort ()
Dim B1 As Integer, B2 As Integer
Application.Screenupdating = False
For B1 = 1 To ThisWorkbook.Sheets.Count
For B2 = B1 To ThisWorkbook.Sheets.Count
If UCase (Sheets (B2) .Name) <UCase (Sheets (B1) .Name) Then Sheets (B2) .Move Before: = Sheets (B1)
Next B2
Next B1
Application.Screenupdating = True
End Sub
Back in the table you call the macro with Alt + F8.
Hope I was able to help you..and would be happy to know if I could help :).
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.