Application.ScreenUpdating = False
A = Range("a3:a" & Range("a65536").End(xlUp).Row)
A = Application.Transpose(A)
A = Split(Application.Trim(Join(A)))
For Each sh In Sheets
For i = 0 To UBound(A)
If A(i) = sh.Name Then
sh.Move after:=Sheets(i + 1)
Exit For
End If
Next i
Next
Sheets(1).Select
End Sub question.rar(31.45 KB, 下载次数: 16)
Application.ScreenUpdating = False
A = Range("a3:a" & Range("a65536").End(xlUp).Row)
A = Application.Transpose(A)
A = Split(Application.Trim(Join(A)))
For Each sh In Sheets
For i = 0 To UBound(A)
If A(i) = sh.Name Then
sh.Move after:=Sheets(i + 1)
Exit For
End If
Next i
Next
Sheets(1).Select
End Sub question.rar(31.45 KB, 下载次数: 16)