|
Sub AA333()
Dim X%, Y%, Z%, M%, K%, G&, D
Set D = CreateObject("Scripting.Dictionary")
With Sheets("发发发")
Y = .Range("E65536").End(3).Row
ReDim ARR1(1 To Y - 2, 1 To 4)
arr = .Range("E3:E" & Y)
For Z = 2 To Sheets.Count
D.Add Sheets(Z).Range("B2").Value, Z
Next Z
For K = 1 To Y - 2
If Y = 3 Then
G = D.Item(arr)
Else
G = D.Item(arr(K, 1))
End If
For M = 1 To 4
Set C = Sheets(G).Range("A1:I65536").Find(.Cells(2, 5 + M), SearchFormat:=True)
If C Is Nothing Then
ARR1(K, M) = ""
Else
ARR1(K, M) = C.Offset(, 1).Value
End If
Next M
Next K
.Range("F3:I" & Y) = ARR1
End With
End Sub
改得有点哈 |
|