|
回复 5楼 一点不自在 的帖子
Private Sub CommandButton1_Click()
Dim i As Integer
Dim row1 As Integer
Dim row2 As Integer
Dim row3 As Integer
row1 = 2
row2 = 21
row3 = 35
i = 2
With Sheet2
Do While .Cells(i, 1) <> ""
Select Case .Cells(i, 1)
Case Is = "部门1"
Sheet1.Cells(row1, 2) = .Cells(i, 1)
Sheet1.Cells(row1, 3) = .Cells(i, 2)
row1 = row1 + 1
Case Is = "部门2"
Sheet1.Cells(row2, 2) = .Cells(i, 1)
Sheet1.Cells(row2, 3) = .Cells(i, 2)
row2 = row2 + 1
Case Is = "部门3"
Sheet1.Cells(row3, 2) = .Cells(i, 1)
Sheet1.Cells(row3, 3) = .Cells(i, 2)
row3 = row3 + 1
Default:
End Select
i = i + 1
Loop
End With
End Sub |
|