|
Sub 字典法复制数据6()
Dim d As Object
Set d = CreateObject("scripting.dictionary")
Dim arr, i As Integer, j As Integer
Dim s As String
Dim brr
With Sheet20
arr = .Range("a1").CurrentRegion
End With
For i = 2 To UBound(arr)
s = arr(i, 11)
d(s) = i
Next
With Sheet08
brr = .Range("a1").CurrentRegion
For i = 2 To UBound(brr)
If Trim(brr(i, 20)) <> "" Then
xh = d(Trim(brr(i, 20)))
If xh <> "" Then
For j = 12 To 19
brr(i, j + 23) = arr(xh, j)
Next j
End If
End If
Next i
.[a1].CurrentRegion = brr
End With
End Sub
|
评分
-
1
查看全部评分
-
|