|
发表于 2013-7-8 13:08
|
显示全部楼层
本楼为最佳答案
在你答复之前,先按青色字体不需要做了一下,附件请测试- Private Sub CommandButton1_Click()
- Application.ScreenUpdating = False
- Dim arr, arr1, i&, j As Byte, k&, l&
- arr = [d6].CurrentRegion
- l = 6
- For j = 15 To 48 Step 11
- arr1 = Cells(6, j).CurrentRegion
- For k = 1 To UBound(arr1)
- For i = 1 To UBound(arr)
- If Join(Application.Index(arr1, k, 0)) = Join(Application.Index(arr, i, 0)) Then
- Cells(l, 59).Resize(, 6) = Application.Index(arr1, k, 0)
- Cells(l, 57) = (j - 4) / 11
- l = l + 1
- End If
- Next i
- Next k
- Next j
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|