|
楼主 |
发表于 2017-9-10 18:21
|
显示全部楼层
Private Sub CommandButton1_Click()
Dim r, k, zt, c, n, w
r = Sheet1.Range("A5").End(xlDown).Row
c = Sheet2.Range("A2").End(xlDown).Row
w = Sheet2.Range("L2").End(xlUp).Row + 1
arr2 = Sheet1.Range("A6:j" & r)
arr = Sheet2.Range("A2:k" & c)
For i = 2 To UBound(arr)
For n = 2 To UBound(arr2)
k = arr(i, 1)
zt = arr2(n, 1)
If k = zt Then
Sheet2.Cells(w, 14) = arr2(n, 2)
Sheet2.Cells(w, 15) = arr2(n, 3)
Sheet2.Cells(w, 16) = arr2(n, 4)
Sheet2.Cells(w, 17) = arr2(n, 5)
Sheet2.Cells(w, 18) = arr2(n, 6)
Sheet2.Cells(w, 19) = arr2(n, 7)
Sheet2.Cells(w, 20) = arr2(n, 8)
Sheet2.Cells(w, 21) = arr2(n, 9)
End If
Next n
Next
End Sub
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?注册
x
|