|
Sub 排列()
Dim i, t, j, m As Long
For i = 2 To 15
With Sheets(i)
t = .Range("w1000").End(xlUp).Row
.Range("w2", "w" & t).Cut .Range("b2")
.Range("n2", "n" & t).Cut .Range("c2")
.Range("m2", "m" & t).Cut .Range("d2")
.Range("v2", "v" & t).Cut .Range("e2")
.Range("p2", "p" & t).Cut .Range("f2")
.Range("q2", "q" & t).Cut .Range("g2")
.Range("r2", "r" & t).Cut .Range("h2")
.Range("s2", "s" & t).Cut .Range("i2")
.Range("t2", "t" & t).Cut .Range("j2")
.Range("u2", "u" & t).Cut .Range("k2")
.Range("o2", "o" & t).Cut .Range("l2")
m = .Range("a1000").End(xlUp).Row
For j = 3 To m
.Cells(j, 12) = Sheets("参数").Range("b3") & "(" & .Cells(j, 12) & ")班"
Next j
End With
Next i
End Sub
|
|