Oct 28 2020 12:53 PM
Oct 28 2020 01:09 PM
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 :).
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.
Oct 28 2020 01:20 PM