Sub 整理学生课表()
m = [a65536].End(3).Row
arr0 = Sheets("选考数据").Range("a1:c" & m)
Range("A1").Offset(0, 0).Resize(m - 1, 3) = arr0
arr1 = Sheets("第1节").Range("a1:d" & m)
arr2 = Sheets("第2节").Range("a1:d" & m)
arr3 = Sheets("第3节").Range("a1:d" & m)
arr = Array(arr1, arr2, arr3)
For i = 0 To 8 Step 4
[a1].CurrentRegion.Sort [c1], 1, , , , , , 1
[a1].CurrentRegion.Sort Cells(1, i + 5), 1, , , , , , 1
k = i / 4
Debug.Print i, k
Range("D1").Offset(0, i).Resize(m - 1, 4) = arr(k)
Next
[a1].CurrentRegion.Sort [a1], 1, , , , , , 1
' Range("A1:O" & m).Sort Key1:=Range("a2"), Order1:=xlAscending, Header:=xlGuess
End Sub
|